using HKB.Common;
using System;
using System.CodeDom.Compiler;
using System.ComponentModel;
using System.ComponentModel.Design;
using System.Data;
using System.Data.Common;
using System.Data.SqlClient;
using System.Diagnostics;
namespace HKB.Data.Dal.S_OrderTableAdapters
{
	[GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0"), DataObject(true), HelpKeyword("vs.data.TableAdapter"), Designer("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"), DesignerCategory("code"), ToolboxItem(true)]
	public class HLShop_OrderTableAdapter : Component
	{
		private SqlDataAdapter _adapter;
		private SqlConnection _connection;
		private SqlCommand[] _commandCollection;
		private bool _clearBeforeFill;
		[System.Diagnostics.DebuggerNonUserCode]
		private SqlDataAdapter Adapter
		{
			get
			{
				if (this._adapter == null)
				{
					this.InitAdapter();
				}
				return this._adapter;
			}
		}
		[System.Diagnostics.DebuggerNonUserCode]
		internal SqlConnection Connection
		{
			get
			{
				if (this._connection == null)
				{
					this.InitConnection();
				}
				return this._connection;
			}
			set
			{
				this._connection = value;
				if (this.Adapter.InsertCommand != null)
				{
					this.Adapter.InsertCommand.Connection = value;
				}
				if (this.Adapter.DeleteCommand != null)
				{
					this.Adapter.DeleteCommand.Connection = value;
				}
				if (this.Adapter.UpdateCommand != null)
				{
					this.Adapter.UpdateCommand.Connection = value;
				}
				for (int i = 0; i < this.CommandCollection.Length; i++)
				{
					if (this.CommandCollection[i] != null)
					{
						this.CommandCollection[i].Connection = value;
					}
				}
			}
		}
		[System.Diagnostics.DebuggerNonUserCode]
		protected SqlCommand[] CommandCollection
		{
			get
			{
				if (this._commandCollection == null)
				{
					this.InitCommandCollection();
				}
				return this._commandCollection;
			}
		}
		[System.Diagnostics.DebuggerNonUserCode]
		public bool ClearBeforeFill
		{
			get
			{
				return this._clearBeforeFill;
			}
			set
			{
				this._clearBeforeFill = value;
			}
		}
		[System.Diagnostics.DebuggerNonUserCode]
		public HLShop_OrderTableAdapter()
		{
			this.ClearBeforeFill = true;
		}
		[System.Diagnostics.DebuggerNonUserCode]
		private void InitAdapter()
		{
			this._adapter = new SqlDataAdapter();
			DataTableMapping dataTableMapping = new DataTableMapping();
			dataTableMapping.SourceTable = "Table";
			dataTableMapping.DataSetTable = "HLShop_Order";
			dataTableMapping.ColumnMappings.Add("OrderFormID", "OrderFormID");
			dataTableMapping.ColumnMappings.Add("OrderFormNum", "OrderFormNum");
			dataTableMapping.ColumnMappings.Add("TradeType", "TradeType");
			dataTableMapping.ColumnMappings.Add("UserID", "UserID");
			dataTableMapping.ColumnMappings.Add("BuyerName", "BuyerName");
			dataTableMapping.ColumnMappings.Add("ShopID", "ShopID");
			dataTableMapping.ColumnMappings.Add("ProductID", "ProductID");
			dataTableMapping.ColumnMappings.Add("ProductName", "ProductName");
			dataTableMapping.ColumnMappings.Add("SalerID", "SalerID");
			dataTableMapping.ColumnMappings.Add("InputTime", "InputTime");
			dataTableMapping.ColumnMappings.Add("UpdateTime", "UpdateTime");
			dataTableMapping.ColumnMappings.Add("ContacterName", "ContacterName");
			dataTableMapping.ColumnMappings.Add("BeginDate", "BeginDate");
			dataTableMapping.ColumnMappings.Add("MoneyReceipt", "MoneyReceipt");
			dataTableMapping.ColumnMappings.Add("Remark", "Remark");
			dataTableMapping.ColumnMappings.Add("MoneyGoods", "MoneyGoods");
			dataTableMapping.ColumnMappings.Add("MoneyTotal", "MoneyTotal");
			dataTableMapping.ColumnMappings.Add("SalerName", "SalerName");
			dataTableMapping.ColumnMappings.Add("OrderMoneyRate", "OrderMoneyRate");
			dataTableMapping.ColumnMappings.Add("HiddenInfo", "HiddenInfo");
			dataTableMapping.ColumnMappings.Add("RegularBus", "RegularBus");
			dataTableMapping.ColumnMappings.Add("TranTeam", "TranTeam");
			dataTableMapping.ColumnMappings.Add("AfterTime", "AfterTime");
			dataTableMapping.ColumnMappings.Add("IsWaitting", "IsWaitting");
			dataTableMapping.ColumnMappings.Add("TeamBuyLeavel", "TeamBuyLeavel");
			dataTableMapping.ColumnMappings.Add("TruePrice", "TruePrice");
			dataTableMapping.ColumnMappings.Add("ServiceTerm", "ServiceTerm");
			dataTableMapping.ColumnMappings.Add("Price_Original", "Price_Original");
			dataTableMapping.ColumnMappings.Add("Price", "Price");
			dataTableMapping.ColumnMappings.Add("PUnit", "PUnit");
			dataTableMapping.ColumnMappings.Add("NeedInvoice", "NeedInvoice");
			dataTableMapping.ColumnMappings.Add("Invoiced", "Invoiced");
			dataTableMapping.ColumnMappings.Add("InvoiceContent", "InvoiceContent");
			dataTableMapping.ColumnMappings.Add("SalerReview", "SalerReview");
			dataTableMapping.ColumnMappings.Add("BuyerReview", "BuyerReview");
			dataTableMapping.ColumnMappings.Add("OnlinePayTradeNo", "OnlinePayTradeNo");
			dataTableMapping.ColumnMappings.Add("OnlinePayType", "OnlinePayType");
			dataTableMapping.ColumnMappings.Add("EndDate", "EndDate");
			dataTableMapping.ColumnMappings.Add("AuctionEndPrice", "AuctionEndPrice");
			dataTableMapping.ColumnMappings.Add("Quantity", "Quantity");
			dataTableMapping.ColumnMappings.Add("Deliver_PaymentType", "Deliver_PaymentType");
			dataTableMapping.ColumnMappings.Add("Charge_Deliver", "Charge_Deliver");
			dataTableMapping.ColumnMappings.Add("Discount_Payment", "Discount_Payment");
			dataTableMapping.ColumnMappings.Add("PresentPoint", "PresentPoint");
			dataTableMapping.ColumnMappings.Add("PresentExp", "PresentExp");
			dataTableMapping.ColumnMappings.Add("PresentMoney", "PresentMoney");
			dataTableMapping.ColumnMappings.Add("PayStatus", "PayStatus");
			dataTableMapping.ColumnMappings.Add("DeliverStatus", "DeliverStatus");
			dataTableMapping.ColumnMappings.Add("Status", "Status");
			dataTableMapping.ColumnMappings.Add("DeliverType", "DeliverType");
			dataTableMapping.ColumnMappings.Add("PaymentType", "PaymentType");
			dataTableMapping.ColumnMappings.Add("Email", "Email");
			dataTableMapping.ColumnMappings.Add("Phone", "Phone");
			dataTableMapping.ColumnMappings.Add("Mobile", "Mobile");
			dataTableMapping.ColumnMappings.Add("ZipCode", "ZipCode");
			dataTableMapping.ColumnMappings.Add("Address", "Address");
			this._adapter.TableMappings.Add(dataTableMapping);
			this._adapter.DeleteCommand = new SqlCommand();
			this._adapter.DeleteCommand.Connection = this.Connection;
			this._adapter.DeleteCommand.CommandText = "DELETE FROM [HLShop_Order] WHERE (([OrderFormID] = @Original_OrderFormID))";
			this._adapter.DeleteCommand.CommandType = CommandType.Text;
			this._adapter.DeleteCommand.Parameters.Add(new SqlParameter("@Original_OrderFormID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "OrderFormID", DataRowVersion.Original, false, null, "", "", ""));
			this._adapter.InsertCommand = new SqlCommand();
			this._adapter.InsertCommand.Connection = this.Connection;
			this._adapter.InsertCommand.CommandText = "INSERT INTO [HLShop_Order] ([OrderFormNum], [TradeType], [UserID], [BuyerName], [ShopID], [ProductID], [ProductName], [SalerID], [InputTime], [UpdateTime], [ContacterName], [BeginDate], [MoneyReceipt], [Remark], [MoneyGoods], [MoneyTotal], [SalerName], [OrderMoneyRate], [HiddenInfo], [RegularBus], [TranTeam], [AfterTime], [IsWaitting], [TeamBuyLeavel], [TruePrice], [ServiceTerm], [Price_Original], [Price], [PUnit], [NeedInvoice], [Invoiced], [InvoiceContent], [SalerReview], [BuyerReview], [OnlinePayTradeNo], [OnlinePayType], [EndDate], [AuctionEndPrice], [Quantity], [Deliver_PaymentType], [Charge_Deliver], [Discount_Payment], [PresentPoint], [PresentExp], [PresentMoney], [PayStatus], [DeliverStatus], [Status], [DeliverType], [PaymentType], [Email], [Phone], [Mobile], [ZipCode], [Address]) VALUES (@OrderFormNum, @TradeType, @UserID, @BuyerName, @ShopID, @ProductID, @ProductName, @SalerID, @InputTime, @UpdateTime, @ContacterName, @BeginDate, @MoneyReceipt, @Remark, @MoneyGoods, @MoneyTotal, @SalerName, @OrderMoneyRate, @HiddenInfo, @RegularBus, @TranTeam, @AfterTime, @IsWaitting, @TeamBuyLeavel, @TruePrice, @ServiceTerm, @Price_Original, @Price, @PUnit, @NeedInvoice, @Invoiced, @InvoiceContent, @SalerReview, @BuyerReview, @OnlinePayTradeNo, @OnlinePayType, @EndDate, @AuctionEndPrice, @Quantity, @Deliver_PaymentType, @Charge_Deliver, @Discount_Payment, @PresentPoint, @PresentExp, @PresentMoney, @PayStatus, @DeliverStatus, @Status, @DeliverType, @PaymentType, @Email, @Phone, @Mobile, @ZipCode, @Address)";
			this._adapter.InsertCommand.CommandType = CommandType.Text;
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@OrderFormNum", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "OrderFormNum", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@TradeType", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TradeType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@UserID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "UserID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@BuyerName", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "BuyerName", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ShopID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ShopID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ProductID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ProductID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ProductName", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "ProductName", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@SalerID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "SalerID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@InputTime", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "InputTime", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@UpdateTime", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "UpdateTime", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ContacterName", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "ContacterName", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@BeginDate", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "BeginDate", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@MoneyReceipt", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "MoneyReceipt", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Remark", SqlDbType.NText, 0, ParameterDirection.Input, 0, 0, "Remark", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@MoneyGoods", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "MoneyGoods", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@MoneyTotal", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "MoneyTotal", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@SalerName", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "SalerName", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@OrderMoneyRate", SqlDbType.Decimal, 0, ParameterDirection.Input, 18, 0, "OrderMoneyRate", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@HiddenInfo", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "HiddenInfo", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@RegularBus", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "RegularBus", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@TranTeam", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TranTeam", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@AfterTime", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "AfterTime", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@IsWaitting", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "IsWaitting", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@TeamBuyLeavel", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TeamBuyLeavel", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@TruePrice", SqlDbType.Decimal, 0, ParameterDirection.Input, 18, 2, "TruePrice", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ServiceTerm", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ServiceTerm", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Price_Original", SqlDbType.Decimal, 0, ParameterDirection.Input, 18, 2, "Price_Original", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Price", SqlDbType.Decimal, 0, ParameterDirection.Input, 18, 2, "Price", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@PUnit", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "PUnit", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@NeedInvoice", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "NeedInvoice", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Invoiced", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "Invoiced", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@InvoiceContent", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "InvoiceContent", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@SalerReview", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "SalerReview", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@BuyerReview", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "BuyerReview", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@OnlinePayTradeNo", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "OnlinePayTradeNo", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@OnlinePayType", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "OnlinePayType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@EndDate", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "EndDate", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@AuctionEndPrice", SqlDbType.Decimal, 0, ParameterDirection.Input, 18, 2, "AuctionEndPrice", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Quantity", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Quantity", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Deliver_PaymentType", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "Deliver_PaymentType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Charge_Deliver", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "Charge_Deliver", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Discount_Payment", SqlDbType.Decimal, 0, ParameterDirection.Input, 18, 2, "Discount_Payment", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@PresentPoint", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "PresentPoint", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@PresentExp", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "PresentExp", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@PresentMoney", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "PresentMoney", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@PayStatus", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "PayStatus", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@DeliverStatus", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "DeliverStatus", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Status", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Status", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@DeliverType", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "DeliverType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@PaymentType", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "PaymentType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Email", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "Email", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Phone", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "Phone", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Mobile", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "Mobile", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ZipCode", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ZipCode", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Address", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "Address", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand = new SqlCommand();
			this._adapter.UpdateCommand.Connection = this.Connection;
			this._adapter.UpdateCommand.CommandText = "UPDATE [HLShop_Order] SET [OrderFormNum] = @OrderFormNum, [TradeType] = @TradeType, [UserID] = @UserID, [BuyerName] = @BuyerName, [ShopID] = @ShopID, [ProductID] = @ProductID, [ProductName] = @ProductName, [SalerID] = @SalerID, [InputTime] = @InputTime, [UpdateTime] = @UpdateTime, [ContacterName] = @ContacterName, [BeginDate] = @BeginDate, [MoneyReceipt] = @MoneyReceipt, [Remark] = @Remark, [MoneyGoods] = @MoneyGoods, [MoneyTotal] = @MoneyTotal, [SalerName] = @SalerName, [OrderMoneyRate] = @OrderMoneyRate, [HiddenInfo] = @HiddenInfo, [RegularBus] = @RegularBus, [TranTeam] = @TranTeam, [AfterTime] = @AfterTime, [IsWaitting] = @IsWaitting, [TeamBuyLeavel] = @TeamBuyLeavel, [TruePrice] = @TruePrice, [ServiceTerm] = @ServiceTerm, [Price_Original] = @Price_Original, [Price] = @Price, [PUnit] = @PUnit, [NeedInvoice] = @NeedInvoice, [Invoiced] = @Invoiced, [InvoiceContent] = @InvoiceContent, [SalerReview] = @SalerReview, [BuyerReview] = @BuyerReview, [OnlinePayTradeNo] = @OnlinePayTradeNo, [OnlinePayType] = @OnlinePayType, [EndDate] = @EndDate, [AuctionEndPrice] = @AuctionEndPrice, [Quantity] = @Quantity, [Deliver_PaymentType] = @Deliver_PaymentType, [Charge_Deliver] = @Charge_Deliver, [Discount_Payment] = @Discount_Payment, [PresentPoint] = @PresentPoint, [PresentExp] = @PresentExp, [PresentMoney] = @PresentMoney, [PayStatus] = @PayStatus, [DeliverStatus] = @DeliverStatus, [Status] = @Status, [DeliverType] = @DeliverType, [PaymentType] = @PaymentType, [Email] = @Email, [Phone] = @Phone, [Mobile] = @Mobile, [ZipCode] = @ZipCode, [Address] = @Address WHERE (([OrderFormID] = @Original_OrderFormID))";
			this._adapter.UpdateCommand.CommandType = CommandType.Text;
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@OrderFormNum", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "OrderFormNum", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@TradeType", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TradeType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@UserID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "UserID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@BuyerName", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "BuyerName", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ShopID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ShopID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ProductID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ProductID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ProductName", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "ProductName", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@SalerID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "SalerID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@InputTime", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "InputTime", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@UpdateTime", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "UpdateTime", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ContacterName", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "ContacterName", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@BeginDate", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "BeginDate", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@MoneyReceipt", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "MoneyReceipt", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Remark", SqlDbType.NText, 0, ParameterDirection.Input, 0, 0, "Remark", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@MoneyGoods", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "MoneyGoods", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@MoneyTotal", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "MoneyTotal", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@SalerName", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "SalerName", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@OrderMoneyRate", SqlDbType.Decimal, 0, ParameterDirection.Input, 18, 0, "OrderMoneyRate", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@HiddenInfo", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "HiddenInfo", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@RegularBus", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "RegularBus", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@TranTeam", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TranTeam", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@AfterTime", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "AfterTime", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@IsWaitting", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "IsWaitting", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@TeamBuyLeavel", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "TeamBuyLeavel", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@TruePrice", SqlDbType.Decimal, 0, ParameterDirection.Input, 18, 2, "TruePrice", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ServiceTerm", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ServiceTerm", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Price_Original", SqlDbType.Decimal, 0, ParameterDirection.Input, 18, 2, "Price_Original", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Price", SqlDbType.Decimal, 0, ParameterDirection.Input, 18, 2, "Price", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@PUnit", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "PUnit", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@NeedInvoice", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "NeedInvoice", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Invoiced", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "Invoiced", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@InvoiceContent", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "InvoiceContent", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@SalerReview", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "SalerReview", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@BuyerReview", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "BuyerReview", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@OnlinePayTradeNo", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "OnlinePayTradeNo", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@OnlinePayType", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "OnlinePayType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@EndDate", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "EndDate", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@AuctionEndPrice", SqlDbType.Decimal, 0, ParameterDirection.Input, 18, 2, "AuctionEndPrice", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Quantity", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Quantity", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Deliver_PaymentType", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "Deliver_PaymentType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Charge_Deliver", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "Charge_Deliver", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Discount_Payment", SqlDbType.Decimal, 0, ParameterDirection.Input, 18, 2, "Discount_Payment", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@PresentPoint", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "PresentPoint", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@PresentExp", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "PresentExp", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@PresentMoney", SqlDbType.Decimal, 0, ParameterDirection.Input, 19, 2, "PresentMoney", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@PayStatus", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "PayStatus", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@DeliverStatus", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "DeliverStatus", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Status", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Status", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@DeliverType", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "DeliverType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@PaymentType", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "PaymentType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Email", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "Email", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Phone", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "Phone", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Mobile", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "Mobile", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ZipCode", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ZipCode", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Address", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "Address", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Original_OrderFormID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "OrderFormID", DataRowVersion.Original, false, null, "", "", ""));
		}
		[System.Diagnostics.DebuggerNonUserCode]
		private void InitConnection()
		{
			this._connection = new SqlConnection();
			this._connection.ConnectionString = Conn.CurrenConnectionStrings;
		}
		[System.Diagnostics.DebuggerNonUserCode]
		private void InitCommandCollection()
		{
			this._commandCollection = new SqlCommand[42];
			this._commandCollection[0] = new SqlCommand();
			this._commandCollection[0].Connection = this.Connection;
			this._commandCollection[0].CommandText = "SELECT     OrderFormID, OrderFormNum, TradeType, UserID, BuyerName, ShopID, ProductID, ProductName, SalerID, InputTime, UpdateTime, ContacterName, \r\n                      BeginDate, MoneyReceipt, Remark, MoneyGoods, MoneyTotal, SalerName, OrderMoneyRate, HiddenInfo, RegularBus, TranTeam, AfterTime, \r\n                      IsWaitting, TeamBuyLeavel, TruePrice, ServiceTerm, Price_Original, Price, PUnit, NeedInvoice, Invoiced, InvoiceContent, SalerReview, BuyerReview, \r\n                      OnlinePayTradeNo, OnlinePayType, EndDate, AuctionEndPrice, Quantity, Deliver_PaymentType, Charge_Deliver, Discount_Payment, PresentPoint, \r\n                      PresentExp, PresentMoney, PayStatus, DeliverStatus, Status, DeliverType, PaymentType, Email, Phone, Mobile, ZipCode, Address\r\nFROM         HLShop_Order";
			this._commandCollection[0].CommandType = CommandType.Text;
			this._commandCollection[1] = new SqlCommand();
			this._commandCollection[1].Connection = this.Connection;
			this._commandCollection[1].CommandText = "DELETE FROM [HLShop_Order] WHERE  userid =@userid and productid=@productid and status=0 \r\n\r\n";
			this._commandCollection[1].CommandType = CommandType.Text;
			this._commandCollection[1].Parameters.Add(new SqlParameter("@userid", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "UserID", DataRowVersion.Original, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@productid", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ProductID", DataRowVersion.Original, false, null, "", "", ""));
			this._commandCollection[2] = new SqlCommand();
			this._commandCollection[2].Connection = this.Connection;
			this._commandCollection[2].CommandText = "PR_GetOrderPerPage";
			this._commandCollection[2].CommandType = CommandType.StoredProcedure;
			this._commandCollection[2].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[2].Parameters.Add(new SqlParameter("@tblName", SqlDbType.VarChar, 255, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[2].Parameters.Add(new SqlParameter("@strGetFields", SqlDbType.VarChar, 1000, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[2].Parameters.Add(new SqlParameter("@fldName", SqlDbType.VarChar, 255, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[2].Parameters.Add(new SqlParameter("@PageSize", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[2].Parameters.Add(new SqlParameter("@PageIndex", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[2].Parameters.Add(new SqlParameter("@OrderType", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[2].Parameters.Add(new SqlParameter("@strWhere", SqlDbType.VarChar, 1500, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[2].Parameters.Add(new SqlParameter("@Counts", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[3] = new SqlCommand();
			this._commandCollection[3].Connection = this.Connection;
			this._commandCollection[3].CommandText = "SELECT Sum(Quantity)As Quantity FROM HLShop_Order\r\nWHERE  ProductID=@ProductID AND TradeType=3 ";
			this._commandCollection[3].CommandType = CommandType.Text;
			this._commandCollection[3].Parameters.Add(new SqlParameter("@ProductID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ProductID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[4] = new SqlCommand();
			this._commandCollection[4].Connection = this.Connection;
			this._commandCollection[4].CommandText = "SELECT TOP 1 HLShop_Order.OrderFormID, HLShop_Order.UserID, \r\n      HLShop_Order.AuctionEndPrice, HLShop_Order.MoneyGoods, \r\n      HLShop_Product.CurrentPrice, HLShop_Product.ImcrementPrice\r\nFROM HLShop_Order INNER JOIN\r\n      HLShop_Product ON HLShop_Order.ProductID = HLShop_Product.ProductID\r\nWHERE (HLShop_Order.AuctionEndPrice =\r\n          (SELECT MAX(AuctionEndPrice) AS Expr1\r\n         FROM HLShop_Order AS HLShop_Order_1\r\n         WHERE (ProductID = @ProductID)))\r\nORDER BY HLShop_Order.OrderFormID Desc";
			this._commandCollection[4].CommandType = CommandType.Text;
			this._commandCollection[4].Parameters.Add(new SqlParameter("@ProductID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[5] = new SqlCommand();
			this._commandCollection[5].Connection = this.Connection;
			this._commandCollection[5].CommandText = "SELECT     'OrderFormID' = CASE WHEN MAX(RegularBus) IS NULL THEN 1 ELSE MAX(RegularBus) END \r\nFROM         HLShop_Order\r\nWHERE     (ProductID = @productid) AND (TeamBuyLeavel = @TeamBuyLeavel)";
			this._commandCollection[5].CommandType = CommandType.Text;
			this._commandCollection[5].Parameters.Add(new SqlParameter("@productid", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ProductID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[5].Parameters.Add(new SqlParameter("@TeamBuyLeavel", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "TeamBuyLeavel", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[6] = new SqlCommand();
			this._commandCollection[6].Connection = this.Connection;
			this._commandCollection[6].CommandText = "SELECT DISTINCT \r\n      HLShop_Order_3.ProductID, HLShop_Order_3.ProductName, \r\n      HLShop_Order_3.MoneyGoods, DATEDIFF(s, GETDATE(), HLShop_Product.EndDate) \r\n      AS LeftTime, HLShop_Order_3.TradeType, HLShop_Order_3.UpdateTime, \r\n      HLShop_Order_3.AuctionEndPrice, HLShop_Order_3.OrderFormID,\r\n          (SELECT MAX(MoneyGoods) AS Expr1\r\n         FROM HLShop_Order\r\n         WHERE (HLShop_Order_1.ProductID = ProductID)) AS AuctionMaxPrice, \r\n      HLShop_Order_3.Status, HLShop_Order_3.BuyerReview, \r\n      HLShop_Order_3.SalerReview, HLShop_Order_3.OnlinePayTradeNo, \r\n      HLShop_Order_3.OnlinePayType, HLShop_Order_3.Quantity,HLShop_Order_3.InputTime,\r\n      HLShop_Order_3.SalerID,HLShop_Order_3.SalerName,HLShop_Order_3.OrderFormNum\r\nFROM HLShop_Order AS HLShop_Order_3 INNER JOIN\r\n      HLShop_Order AS HLShop_Order_1 ON \r\n      HLShop_Order_3.ProductID = HLShop_Order_1.ProductID INNER JOIN\r\n      HLShop_Product ON \r\n      HLShop_Order_3.ProductID = HLShop_Product.ProductID\r\nWHERE (HLShop_Order_3.OrderFormID IN\r\n          (SELECT MAX(OrderFormID) AS id\r\n         FROM HLShop_Order AS HLShop_Order_2\r\n         WHERE (UserID = @UserID) AND (TradeType =2)\r\n         GROUP BY ProductName))";
			this._commandCollection[6].CommandType = CommandType.Text;
			this._commandCollection[6].Parameters.Add(new SqlParameter("@UserID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[7] = new SqlCommand();
			this._commandCollection[7].Connection = this.Connection;
			this._commandCollection[7].CommandText = "Select Count(OrderFormID) As OrderFormID From HLShop_Order \r\nWHERE ((HLShop_Order.MoneyReceipt<=0 AND HLShop_Order.PayStatus!='免定金') or HLShop_Order.PayStatus='等待付款') AND (HLShop_Order.SalerID=@SalerID) AND\r\n                      (HLShop_Order.TradeType=3) AND\r\n                      (DateDiff(s, GetDate(),(Select DATEADD(hh,2,HLSHop_Order.EndDate) AS timeframe))>0) AND (HLSHop_Order.IsWaitting=1) AND (HLSHop_Order.ProductID=@ProductID)";
			this._commandCollection[7].CommandType = CommandType.Text;
			this._commandCollection[7].Parameters.Add(new SqlParameter("@SalerID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "SalerID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[7].Parameters.Add(new SqlParameter("@ProductID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ProductID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[8] = new SqlCommand();
			this._commandCollection[8].Connection = this.Connection;
			this._commandCollection[8].CommandText = "Pr_GetOrderByManyCondition";
			this._commandCollection[8].CommandType = CommandType.StoredProcedure;
			this._commandCollection[8].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[8].Parameters.Add(new SqlParameter("@UserIDSalerID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[8].Parameters.Add(new SqlParameter("@Moment", SqlDbType.VarChar, 20, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[8].Parameters.Add(new SqlParameter("@BeginDate", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[8].Parameters.Add(new SqlParameter("@EndDate", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[8].Parameters.Add(new SqlParameter("@OrderFormNum", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[8].Parameters.Add(new SqlParameter("@BeginOrderID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[8].Parameters.Add(new SqlParameter("@EndOrderID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[8].Parameters.Add(new SqlParameter("@BeginMoney", SqlDbType.Decimal, 13, ParameterDirection.Input, 25, 2, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[8].Parameters.Add(new SqlParameter("@EndMoney", SqlDbType.Decimal, 13, ParameterDirection.Input, 25, 2, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[8].Parameters.Add(new SqlParameter("@Status", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[8].Parameters.Add(new SqlParameter("@PayStatic", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[8].Parameters.Add(new SqlParameter("@DeliverStatus", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[8].Parameters.Add(new SqlParameter("@UserName", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[8].Parameters.Add(new SqlParameter("@ContacterName", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[8].Parameters.Add(new SqlParameter("@Email", SqlDbType.VarChar, 200, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[8].Parameters.Add(new SqlParameter("@Address", SqlDbType.VarChar, 200, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[8].Parameters.Add(new SqlParameter("@Phone", SqlDbType.VarChar, 20, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[8].Parameters.Add(new SqlParameter("@Mobile", SqlDbType.VarChar, 12, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[8].Parameters.Add(new SqlParameter("@Remark", SqlDbType.VarChar, 200, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[8].Parameters.Add(new SqlParameter("@ProductName", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[8].Parameters.Add(new SqlParameter("@TransSize", SqlDbType.VarChar, 10, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[9] = new SqlCommand();
			this._commandCollection[9].Connection = this.Connection;
			this._commandCollection[9].CommandText = "SELECT HLShop_Order.Address, HLShop_Order.AfterTime, HLShop_Order.AuctionEndPrice, \r\n      HLShop_Order.BeginDate, HLShop_Order.BuyerName, HLShop_Order.BuyerReview, \r\n      HLShop_Order.Charge_Deliver, HLShop_Order.ContacterName, \r\n      HLShop_Order.DeliverStatus, HLShop_Order.DeliverType, \r\n      HLShop_Order.Deliver_PaymentType, HLShop_Order.Discount_Payment, \r\n      HLShop_Order.Email, HLShop_Order.EndDate, HLShop_Order.InputTime, \r\n      HLShop_Order.InvoiceContent, HLShop_Order.Invoiced, HLShop_Order.IsWaitting, \r\n      HLShop_Order.Mobile, HLShop_Order.MoneyGoods, HLShop_Order.MoneyReceipt, \r\n      HLShop_Order.MoneyTotal, HLShop_Order.NeedInvoice, \r\n      HLShop_Order.OnlinePayTradeNo, HLShop_Order.OnlinePayType, \r\n      HLShop_Order.OrderFormID, HLShop_Order.OrderFormNum, \r\n      HLShop_Order.OrderMoneyRate, HLShop_Order.PUnit, HLShop_Order.PayStatus, \r\n      HLShop_Order.PaymentType, HLShop_Order.Phone, HLShop_Order.PresentExp, \r\n      HLShop_Order.PresentMoney, HLShop_Order.PresentPoint, HLShop_Order.Price, \r\n      HLShop_Order.Price_Original, HLShop_Order.ProductID, \r\n      HLShop_Order.ProductName, HLShop_Order.Quantity, HLShop_Order.RegularBus, \r\n      HLShop_Order.Remark, HLShop_Order.SalerID, HLShop_Order.SalerName, \r\n      HLShop_Order.SalerReview, HLShop_Order.ServiceTerm, HLShop_Order.ShopID, \r\n      HLShop_Order.Status, HLShop_Order.TeamBuyLeavel, HLShop_Order.TradeType, \r\n      HLShop_Order.TranTeam, HLShop_Order.TruePrice, HLShop_Order.UpdateTime, \r\n      HLShop_Order.UserID, HLShop_Order.ZipCode, HLShop_Product.TaxRate\r\nFROM HLShop_Order INNER JOIN\r\n      HLShop_Product ON HLShop_Order.ProductID = HLShop_Product.ProductID\r\nWHERE (HLShop_Order.OrderFormNum = @OrderFormNum)  ";
			this._commandCollection[9].CommandType = CommandType.Text;
			this._commandCollection[9].Parameters.Add(new SqlParameter("@OrderFormNum", SqlDbType.NVarChar, 100, ParameterDirection.Input, 0, 0, "OrderFormNum", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[10] = new SqlCommand();
			this._commandCollection[10].Connection = this.Connection;
			this._commandCollection[10].CommandText = "SELECT HLShop_Order.Address, HLShop_Order.AfterTime, HLShop_Order.AuctionEndPrice, \r\n      HLShop_Order.BeginDate, HLShop_Order.BuyerName, HLShop_Order.BuyerReview, \r\n      HLShop_Order.Charge_Deliver, HLShop_Order.ContacterName, \r\n      HLShop_Order.DeliverStatus, HLShop_Order.DeliverType, \r\n      HLShop_Order.Deliver_PaymentType, HLShop_Order.Discount_Payment, \r\n      HLShop_Order.Email, HLShop_Order.EndDate, HLShop_Order.InputTime, \r\n      HLShop_Order.InvoiceContent, HLShop_Order.Invoiced, HLShop_Order.IsWaitting, \r\n      HLShop_Order.Mobile, HLShop_Order.MoneyGoods, HLShop_Order.MoneyReceipt, \r\n      HLShop_Order.MoneyTotal, HLShop_Order.NeedInvoice, \r\n      HLShop_Order.OnlinePayTradeNo, HLShop_Order.OnlinePayType, \r\n      HLShop_Order.OrderFormID, HLShop_Order.OrderFormNum, \r\n      HLShop_Order.OrderMoneyRate, HLShop_Order.PUnit, HLShop_Order.PayStatus, \r\n      HLShop_Order.PaymentType, HLShop_Order.Phone, HLShop_Order.PresentExp, \r\n      HLShop_Order.PresentMoney, HLShop_Order.PresentPoint, HLShop_Order.Price, \r\n      HLShop_Order.Price_Original, HLShop_Order.ProductID, \r\n      HLShop_Order.ProductName, HLShop_Order.Quantity, HLShop_Order.RegularBus, \r\n      HLShop_Order.Remark, HLShop_Order.SalerID, HLShop_Order.SalerName, \r\n      HLShop_Order.SalerReview, HLShop_Order.ServiceTerm, HLShop_Order.ShopID, \r\n      HLShop_Order.Status, HLShop_Order.TeamBuyLeavel, HLShop_Order.TradeType, \r\n      HLShop_Order.TranTeam, HLShop_Order.TruePrice, HLShop_Order.UpdateTime, \r\n      HLShop_Order.UserID, HLShop_Order.ZipCode, HLShop_Product.TaxRate\r\nFROM HLShop_Order INNER JOIN\r\n      HLShop_Product ON HLShop_Order.ProductID = HLShop_Product.ProductID\r\nWHERE (HLShop_Order.OrderFormID = @OrderFormID)";
			this._commandCollection[10].CommandType = CommandType.Text;
			this._commandCollection[10].Parameters.Add(new SqlParameter("@OrderFormID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "OrderFormID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[11] = new SqlCommand();
			this._commandCollection[11].Connection = this.Connection;
			this._commandCollection[11].CommandText = "SELECT     SUM(Quantity) AS OrderFormID\r\nFROM         HLShop_Order\r\nWHERE      AND (Status <>1) AND (DeliverStatus <>1) AND (DeliverStatus <> 2) AND \r\n                      (TradeType <> 2) AND (ProductID = @productid)\r\nGROUP BY ProductID";
			this._commandCollection[11].CommandType = CommandType.Text;
			this._commandCollection[11].Parameters.Add(new SqlParameter("@productid", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ProductID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[12] = new SqlCommand();
			this._commandCollection[12].Connection = this.Connection;
			this._commandCollection[12].CommandText = "SELECT Address, AfterTime, AuctionEndPrice, BeginDate, BuyerName, BuyerReview, Charge_Deliver, ContacterName, DeliverStatus, DeliverType, Deliver_PaymentType, Discount_Payment, Email, EndDate, HiddenInfo, InputTime, InvoiceContent, Invoiced, IsWaitting, Mobile, MoneyGoods, MoneyReceipt, MoneyTotal, NeedInvoice, OnlinePayTradeNo, OnlinePayType, OrderFormID, OrderFormNum, OrderMoneyRate, PUnit, PayStatus, PaymentType, Phone, PresentExp, PresentMoney, PresentPoint, Price, Price_Original, ProductID, ProductName, Quantity, RegularBus, Remark, SalerID, SalerName, SalerReview, ServiceTerm, ShopID, Status, TeamBuyLeavel, TradeType, TranTeam, TruePrice, UpdateTime, UserID, ZipCode FROM HLShop_Order WHERE (ProductID = @productid) AND (TradeType = 3) AND (TeamBuyLeavel <> - 1) AND (TeamBuyLeavel = @TeamBuyLeavel) AND (OrderFormID <> @OrderFormID) AND (RegularBus = @RegularBus)";
			this._commandCollection[12].CommandType = CommandType.Text;
			this._commandCollection[12].Parameters.Add(new SqlParameter("@productid", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ProductID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[12].Parameters.Add(new SqlParameter("@TeamBuyLeavel", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "TeamBuyLeavel", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[12].Parameters.Add(new SqlParameter("@OrderFormID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "OrderFormID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[12].Parameters.Add(new SqlParameter("@RegularBus", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "RegularBus", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13] = new SqlCommand();
			this._commandCollection[13].Connection = this.Connection;
			this._commandCollection[13].CommandText = "SELECT Address, AfterTime, AuctionEndPrice, BeginDate, BuyerName, BuyerReview, Charge_Deliver, ContacterName, DeliverStatus, DeliverType, Deliver_PaymentType, Discount_Payment, Email, EndDate, HiddenInfo, InputTime, InvoiceContent, Invoiced, IsWaitting, Mobile, MoneyGoods, MoneyReceipt, MoneyTotal, NeedInvoice, OnlinePayTradeNo, OnlinePayType, OrderFormID, OrderFormNum, OrderMoneyRate, PUnit, PayStatus, PaymentType, Phone, PresentExp, PresentMoney, PresentPoint, Price, Price_Original, ProductID, ProductName, Quantity, RegularBus, Remark, SalerID, SalerName, SalerReview, ServiceTerm, ShopID, Status, TeamBuyLeavel, TradeType, TranTeam, TruePrice, UpdateTime, UserID, ZipCode FROM HLShop_Order WHERE (UserID = @UserID) AND (ProductID = @ProductID) OR (ProductID = @ProductID) AND (SalerID = @UserID)";
			this._commandCollection[13].CommandType = CommandType.Text;
			this._commandCollection[13].Parameters.Add(new SqlParameter("@UserID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "UserID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13].Parameters.Add(new SqlParameter("@ProductID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ProductID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14] = new SqlCommand();
			this._commandCollection[14].Connection = this.Connection;
			this._commandCollection[14].CommandText = "PR_PageListForAdmin";
			this._commandCollection[14].CommandType = CommandType.StoredProcedure;
			this._commandCollection[14].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@tblName", SqlDbType.VarChar, 255, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@strGetFields", SqlDbType.VarChar, 1000, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@fldName", SqlDbType.VarChar, 255, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@PageSize", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@PageIndex", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@OrderType", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@strWhere", SqlDbType.VarChar, 1500, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14].Parameters.Add(new SqlParameter("@Counts", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[15] = new SqlCommand();
			this._commandCollection[15].Connection = this.Connection;
			this._commandCollection[15].CommandText = "PR_GetSaleCount";
			this._commandCollection[15].CommandType = CommandType.StoredProcedure;
			this._commandCollection[15].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[15].Parameters.Add(new SqlParameter("@SalerID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[15].Parameters.Add(new SqlParameter("@productname", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[15].Parameters.Add(new SqlParameter("@Monents", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[15].Parameters.Add(new SqlParameter("@BeginDate", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[15].Parameters.Add(new SqlParameter("@EndDate", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[16] = new SqlCommand();
			this._commandCollection[16].Connection = this.Connection;
			this._commandCollection[16].CommandText = "PR_GetSaleItem";
			this._commandCollection[16].CommandType = CommandType.StoredProcedure;
			this._commandCollection[16].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[16].Parameters.Add(new SqlParameter("@SalerID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[16].Parameters.Add(new SqlParameter("@productname", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[16].Parameters.Add(new SqlParameter("@Monents", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[16].Parameters.Add(new SqlParameter("@BeginDate", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[16].Parameters.Add(new SqlParameter("@EndDate", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[16].Parameters.Add(new SqlParameter("@UserName", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[17] = new SqlCommand();
			this._commandCollection[17].Connection = this.Connection;
			this._commandCollection[17].CommandText = "SELECT HLShop_Order.OrderFormID, HLShop_Order.OrderFormNum, \r\n      HLShop_Order.UserID, HLShop_Order.ProductID, HLShop_Order.ProductName, \r\n      HLShop_Order.SalerID, HLShop_Order.MoneyGoods, HLShop_Order.InputTime, \r\n      HLShop_Order.Price, HLShop_Order.TruePrice, HLShop_Order.Quantity, \r\n      HL_User.UserName, HLShop_Order.PUnit, HLShop_Order.PresentExp, \r\n      HLShop_Order.MoneyTotal\r\nFROM HLShop_Order INNER JOIN\r\n      HL_User ON HLShop_Order.UserID = HL_User.UserID\r\nWHERE (HLShop_Order.Status = '交易成功') AND (HLShop_Order.ProductID = @ProductID)";
			this._commandCollection[17].CommandType = CommandType.Text;
			this._commandCollection[17].Parameters.Add(new SqlParameter("@ProductID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ProductID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[18] = new SqlCommand();
			this._commandCollection[18].Connection = this.Connection;
			this._commandCollection[18].CommandText = "\r\n                      SELECT DISTINCT\r\n                      HLShop_Order_3.ProductID, HLShop_Order_3.ProductName,\r\n                      HLShop_Order_3.MoneyGoods, DATEDIFF(s, GETDATE(), HLShop_Product.EndDate)\r\n                      AS LeftTime, HLShop_Order_3.TradeType, HLShop_Order_3.UpdateTime,\r\n                      HLShop_Order_3.AuctionEndPrice, HLShop_Order_3.OrderFormID,\r\n                      (SELECT MAX(MoneyGoods) AS Expr1\r\n                      FROM HLShop_Order\r\n                      WHERE (HLShop_Order_1.ProductID = ProductID)) AS AuctionMaxPrice,\r\n                      HLShop_Order_3.Status, HLShop_Order_3.BuyerReview,\r\n                      HLShop_Order_3.SalerReview, HLShop_Order_3.OnlinePayTradeNo,\r\n                      HLShop_Order_3.OnlinePayType, HLShop_Order_3.Quantity,HLShop_Order_3.UserID,\r\n                      HLShop_Order_3.BuyerName,HLShop_Order_3.OrderFormNum,HLShop_Order_3.Address,\r\n                      HLShop_Order_3.InputTime\r\n                      FROM HLShop_Order AS HLShop_Order_3 INNER JOIN\r\n                      HLShop_Order AS HLShop_Order_1 ON\r\n                      HLShop_Order_3.ProductID = HLShop_Order_1.ProductID INNER JOIN\r\n                      HLShop_Product ON\r\n                      HLShop_Order_3.ProductID = HLShop_Product.ProductID\r\n                      WHERE (HLShop_Order_3.OrderFormID IN\r\n                      (SELECT MAX(OrderFormID) AS id\r\n                      FROM HLShop_Order AS HLShop_Order_2\r\n                      WHERE (SalerID = @UserID) AND (TradeType = 2) AND (Status!='出局')\r\n                      GROUP BY ProductName))";
			this._commandCollection[18].CommandType = CommandType.Text;
			this._commandCollection[18].Parameters.Add(new SqlParameter("@UserID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[19] = new SqlCommand();
			this._commandCollection[19].Connection = this.Connection;
			this._commandCollection[19].CommandText = "SELECT DISTINCT \r\n      HLShop_Order.BuyerName, HLShop_Order.ProductID, HLShop_Order.ProductName, \r\n      HLShop_Order.Quantity, HLShop_Order.SalerID, HLShop_Order.SalerName, \r\n      HLShop_Order.ShopID, HLShop_Order.Status, HLShop_Order.TradeType, \r\n      HLShop_Order.UpdateTime, HLShop_Order.UserID, HLShop_Order.MoneyGoods, \r\n      HLShop_Order.InputTime, HLShop_Order.OnlinePayType, \r\n      HLShop_Order.OnlinePayTradeNo, HLShop_Order.EndDate, \r\n      HLShop_Order.OrderFormID, HLShop_Order.OrderFormNum, \r\n      HLShop_Order.BuyerReview, HLShop_Order.SalerReview\r\nFROM HLShop_Order INNER JOIN\r\n      HL_User ON HLShop_Order.UserID = HL_User.UserID\r\nWHERE (HLShop_Order.SalerID = @SalerID) AND \r\n      (HLShop_Order.TradeType = @TradeType)\r\nORDER BY HLShop_Order.InputTime DESC";
			this._commandCollection[19].CommandType = CommandType.Text;
			this._commandCollection[19].Parameters.Add(new SqlParameter("@SalerID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "SalerID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[19].Parameters.Add(new SqlParameter("@TradeType", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, "TradeType", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[20] = new SqlCommand();
			this._commandCollection[20].Connection = this.Connection;
			this._commandCollection[20].CommandText = "SELECT DISTINCT \r\n      HLShop_Order.ProductID, HLShop_Order.ProductName, HLShop_Order.UserID, \r\n      HLShop_Order.ShopID, HLShop_Order.SalerID, HLShop_Order.MoneyGoods, \r\n      HLShop_Order.ContacterName, HLShop_Order.Status, HL_User.UserName, \r\n      HLShop_Order.OrderFormNum, HLShop_Order.TradeType, HLShop_Order.SalerName, \r\n      HLShop_Order.InputTime, HLShop_Order.OnlinePayType, \r\n      HLShop_Order.OnlinePayTradeNo,HLShop_Order.EndDate, \r\nHLShop_Order.OrderFormID, HLShop_Order.BuyerReview, \r\n      HLShop_Order.SalerReview\r\nFROM HLShop_Order INNER JOIN\r\n      HL_User ON HLShop_Order.SalerID = HL_User.UserID\r\nWHERE (HLShop_Order.UserID = @UserID) AND \r\n      (HLShop_Order.TradeType = @TradeType)\r\nORDER BY HLShop_Order.InputTime DESC";
			this._commandCollection[20].CommandType = CommandType.Text;
			this._commandCollection[20].Parameters.Add(new SqlParameter("@UserID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "UserID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[20].Parameters.Add(new SqlParameter("@TradeType", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, "TradeType", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[21] = new SqlCommand();
			this._commandCollection[21].Connection = this.Connection;
			this._commandCollection[21].CommandText = "Select Sum(Quantity)As Quantity From HLShop_Order WHERE ProductID=@ProductID AND TradeType=3 AND RegularBus<=@RegularBus AND EndDate>=GetDate() AND Status=0  AND (PayStatus!=0)";
			this._commandCollection[21].CommandType = CommandType.Text;
			this._commandCollection[21].Parameters.Add(new SqlParameter("@ProductID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ProductID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[21].Parameters.Add(new SqlParameter("@RegularBus", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "RegularBus", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[22] = new SqlCommand();
			this._commandCollection[22].Connection = this.Connection;
			this._commandCollection[22].CommandText = "Select Max(TeamBuyLeavel)As OrderFormID,TranTeam From HLShop_Order WHERE ProductID=@ProductID\r\nGroup By TranTeam";
			this._commandCollection[22].CommandType = CommandType.Text;
			this._commandCollection[22].Parameters.Add(new SqlParameter("@ProductID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ProductID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[23] = new SqlCommand();
			this._commandCollection[23].Connection = this.Connection;
			this._commandCollection[23].CommandText = "SELECT Max(TeamBuyLeavel) FROM HLShop_Order\r\nWHERE ProductID=@ProductID AND TranTeam=@TranTeam";
			this._commandCollection[23].CommandType = CommandType.Text;
			this._commandCollection[23].Parameters.Add(new SqlParameter("@ProductID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ProductID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[23].Parameters.Add(new SqlParameter("@TranTeam", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "TranTeam", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[24] = new SqlCommand();
			this._commandCollection[24].Connection = this.Connection;
			this._commandCollection[24].CommandText = "\r\n                      SELECT  MAX(HLShop_Order.ProductID) AS ProductID,HLShop_Product.ProductName,DATEDIFF(s, GETDATE(), HLShop_Product.EndDate) AS LeftTime,\r\n                      HLSHop_Order.TranTeam,HLSHop_Order.TeamBuyLeavel,HLSHop_Order.Punit,\r\n                      Sum(HLShop_Order.Quantity) As OrderQuantityNum,\r\n                      Count(HLShop_Order.OrderFormID) As OrderNum,\r\n                      Max(HLShop_Order.UpdateTime)As UpdateTime,HLShop_Order.Status,Max(HLShop_Order.OrderFormID)As OrderFormID\r\n                      FROM HLShop_Order inner join HLShop_Product On HLShop_Product.ProductID=HLShop_Order.ProductID\r\n\r\n                      WHERE (HLShop_Order.SalerID=@SalerID) AND\r\n                      (HLShop_Order.TradeType=3) AND\r\n                      (HLShop_Order.Status=@Status) AND\r\n                      (HLShop_Order.EndDate>GetDate()) AND\r\n                      (HLSHop_Order.IsWaitting=@IsWaitting)\r\n                      GROUP BY HLShop_Order.ProductID,HLSHop_Order.Punit,HLShop_Product.ProductName,HLShop_Product.EndDate,HLShop_Order.Status,HLSHop_Order.TranTeam,HLSHop_Order.TeamBuyLeavel";
			this._commandCollection[24].CommandType = CommandType.Text;
			this._commandCollection[24].Parameters.Add(new SqlParameter("@SalerID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "SalerID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[24].Parameters.Add(new SqlParameter("@Status", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, "Status", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[24].Parameters.Add(new SqlParameter("@IsWaitting", SqlDbType.Bit, 1, ParameterDirection.Input, 0, 0, "IsWaitting", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[25] = new SqlCommand();
			this._commandCollection[25].Connection = this.Connection;
			this._commandCollection[25].CommandText = "SELECT Address, AfterTime, AuctionEndPrice, BeginDate, BuyerName, BuyerReview, Charge_Deliver, ContacterName, DeliverStatus, DeliverType, Deliver_PaymentType, Discount_Payment, Email, EndDate, HiddenInfo, InputTime, InvoiceContent, Invoiced, IsWaitting, Mobile, MoneyGoods, MoneyReceipt, MoneyTotal, NeedInvoice, OnlinePayTradeNo, OnlinePayType, OrderFormID, OrderFormNum, OrderMoneyRate, PUnit, PayStatus, PaymentType, Phone, PresentExp, PresentMoney, PresentPoint, Price, Price_Original, ProductID, ProductName, Quantity, RegularBus, Remark, SalerID, SalerName, SalerReview, ServiceTerm, ShopID, Status, TeamBuyLeavel, TradeType, TranTeam, TruePrice, UpdateTime, UserID, ZipCode FROM HLShop_Order WHERE (TradeType = 3) AND (UserID = @UserID) AND (DATEDIFF(s, GETDATE(), EndDate) > 0) AND (Status = 0) ORDER BY OrderFormID DESC";
			this._commandCollection[25].CommandType = CommandType.Text;
			this._commandCollection[25].Parameters.Add(new SqlParameter("@UserID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "UserID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[26] = new SqlCommand();
			this._commandCollection[26].Connection = this.Connection;
			this._commandCollection[26].CommandText = "SELECT HLShop_Order.ProductID,HLShop_Product.ProductName,\r\nHLSHop_Order.TranTeam,HLSHop_Order.BuyerName,HLSHop_Order.UserID,\r\nHLShop_Order.Quantity,HLShop_Order.TranTeam,\r\nHLShop_Order.OrderFormID,HLShop_Order.OrderFormNum,HLShop_Order.MoneyTotal,\r\nHLShop_Order.InputTime,HLShop_Order.Status,HLShop_Order.MoneyGoods,HLShop_Order.PayStatus,HLShop_Order.MoneyReceipt \r\n   FROM HLShop_Order inner join HLShop_Product On HLShop_Product.ProductID=HLShop_Order.ProductID\r\n\r\nWHERE (HLShop_Order.SalerID=@SalerID) AND (HLSHop_Order.ProductID=@ProductID) AND \r\n(HLShop_Order.TradeType=3) AND\r\n(HLShop_Order.Status=0 OR HLShop_Order.Status=1) AND \r\n(HLSHop_Order.IsWaitting=0)  AND \r\n(HLSHop_Order.TranTeam=@TranTeam) AND (HLSHop_Order.TeamBuyLeavel=@TeamBuyLeavel)\r\n";
			this._commandCollection[26].CommandType = CommandType.Text;
			this._commandCollection[26].Parameters.Add(new SqlParameter("@SalerID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "SalerID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[26].Parameters.Add(new SqlParameter("@ProductID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ProductID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[26].Parameters.Add(new SqlParameter("@TranTeam", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "TranTeam", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[26].Parameters.Add(new SqlParameter("@TeamBuyLeavel", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "TeamBuyLeavel", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[27] = new SqlCommand();
			this._commandCollection[27].Connection = this.Connection;
			this._commandCollection[27].CommandText = "SELECT     HLShop_Order.OrderFormID, HLShop_Order.OrderFormNum, HLShop_Order.TradeType, HLShop_Order.UserID, HLShop_Order.BuyerName, \r\n                      HLShop_Order.ShopID, HLShop_Order.ProductID, HLShop_Order.ProductName, HLShop_Order.SalerID, HLShop_Order.SalerName, \r\n                      HLShop_Order.MoneyTotal, HLShop_Order.MoneyGoods, HLShop_Order.Remark, HLShop_Order.MoneyReceipt, HLShop_Order.BeginDate, \r\n                      HLShop_Order.InputTime, HLShop_Order.UpdateTime, HLShop_Order.ContacterName, HLShop_Order.Address, HLShop_Order.ZipCode, \r\n                      HLShop_Order.Mobile, HLShop_Order.Phone, HLShop_Order.Email, HLShop_Order.PaymentType, HLShop_Order.DeliverType, HLShop_Order.Status, \r\n                      HLShop_Order.DeliverStatus, HLShop_Order.PresentMoney, HLShop_Order.PresentPoint, HLShop_Order.PresentExp, \r\n                      HLShop_Order.Discount_Payment, HLShop_Order.Charge_Deliver, HLShop_Order.Quantity, HLShop_Order.AuctionEndPrice, HLShop_Order.EndDate, \r\n                      HLShop_Order.OnlinePayType, HLShop_Order.OnlinePayTradeNo, HLShop_Order.BuyerReview, HLShop_Order.SalerReview, \r\n                      HLShop_Order.InvoiceContent, HLShop_Order.Invoiced, HLShop_Order.NeedInvoice, HLShop_Order.PUnit, HLShop_Order.Price, \r\n                      HLShop_Order.Price_Original, HLShop_Order.ServiceTerm, HLShop_Order.TruePrice, HLShop_Order.TeamBuyLeavel, HLShop_Order.IsWaitting, \r\n                      HLShop_Order.AfterTime, HLShop_Order.TranTeam, HLShop_Order.RegularBus, HLShop_Product.Stocks, HLShop_Product.TeamCurrentNumber5, \r\n                      HLShop_Product.TeamCurrentNumber4, HLShop_Product.TeamCurrentNumber3, HLShop_Product.TeamCurrentNumber2, \r\n                      HLShop_Product.TeamNumber51, HLShop_Product.TeamCurrentNumber1, HLShop_Product.TeamNumber5, HLShop_Product.TeamName, \r\n                      HLShop_Product.TeamNum, HLShop_Product.TeamPrice1, HLShop_Product.TempSubScriptionRate, HLShop_Product.TeamNumber1, \r\n                      HLShop_Product.TeamNumber11, HLShop_Product.TeamPrice2, HLShop_Product.TeamNumber2, HLShop_Product.TeamNumber21, \r\n                      HLShop_Product.TeamPrice3, HLShop_Product.TeamNumber3, HLShop_Product.TeamNumber31, HLShop_Product.TeamPrice4, \r\n                      HLShop_Product.TeamNumber4, HLShop_Product.TeamNumber41, HLShop_Product.TeamPrice5, HLShop_Product.EndDate AS ProEndDate, \r\n                      HLShop_Product.StandPrice, HLShop_Product.StandPrice * HLShop_Order.Quantity * HLShop_Product.TempSubScriptionRate / 100 AS submoney, \r\n                      HLShop_Product.Discount, HLShop_Product.PresentMoney AS Expr1, HLShop_Product.PresentPoint AS Expr2, HLShop_Product.PresentExp AS Expr3, \r\n                      HLShop_Product.Discount1, HLShop_Product.PresentMoney1, HLShop_Product.PresentPoint1, HLShop_Product.PresentExp1, \r\n                      HLShop_Product.Discount2, HLShop_Product.PresentMoney2, HLShop_Product.PresentPoint2, HLShop_Product.PresentExp2, \r\n                      HLShop_Product.Discount3, HLShop_Product.PresentMoney3, HLShop_Product.PresentPoint3, HLShop_Product.PresentExp3, \r\n                      HLShop_Product.ProductID AS Expr4\r\nFROM         HLShop_Order INNER JOIN\r\n                      HLShop_Product ON HLShop_Order.ProductID = HLShop_Product.ProductID\r\nWHERE     (HLShop_Order.Status =0)  and  hlshop_order. salerid=@salerID";
			this._commandCollection[27].CommandType = CommandType.Text;
			this._commandCollection[27].Parameters.Add(new SqlParameter("@salerID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "SalerID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[28] = new SqlCommand();
			this._commandCollection[28].Connection = this.Connection;
			this._commandCollection[28].CommandText = "SELECT Address, AfterTime, AuctionEndPrice, BeginDate, BuyerName, BuyerReview, Charge_Deliver, ContacterName, DeliverStatus, DeliverType, Deliver_PaymentType, Discount_Payment, Email, EndDate, HiddenInfo, InputTime, InvoiceContent, Invoiced, IsWaitting, Mobile, MoneyGoods, MoneyReceipt, MoneyTotal, NeedInvoice, OnlinePayTradeNo, OnlinePayType, OrderFormID, OrderFormNum, OrderMoneyRate, PUnit, PayStatus, PaymentType, Phone, PresentExp, PresentMoney, PresentPoint, Price, Price_Original, ProductID, ProductName, Quantity, RegularBus, Remark, SalerID, SalerName, SalerReview, ServiceTerm, ShopID, Status, TeamBuyLeavel, TradeType, TranTeam, TruePrice, UpdateTime, UserID, ZipCode FROM HLShop_Order WHERE (ProductID = @Productid) AND (EndDate >= GETDATE()) AND (Status = 0) AND (PayStatus =0 OR PayStatus =1)";
			this._commandCollection[28].CommandType = CommandType.Text;
			this._commandCollection[28].Parameters.Add(new SqlParameter("@Productid", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ProductID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[29] = new SqlCommand();
			this._commandCollection[29].Connection = this.Connection;
			this._commandCollection[29].CommandText = "SELECT Address, AfterTime, AuctionEndPrice, BeginDate, BuyerName, BuyerReview, Charge_Deliver, ContacterName, DeliverStatus, DeliverType, Deliver_PaymentType, Discount_Payment, Email, EndDate, HiddenInfo, InputTime, InvoiceContent, Invoiced, IsWaitting, Mobile, MoneyGoods, MoneyReceipt, MoneyTotal, NeedInvoice, OnlinePayTradeNo, OnlinePayType, OrderFormID, OrderFormNum, OrderMoneyRate, PUnit, PayStatus, PaymentType, Phone, PresentExp, PresentMoney, PresentPoint, Price, Price_Original, ProductID, ProductName, Quantity, RegularBus, Remark, SalerID, SalerName, SalerReview, ServiceTerm, ShopID, Status, TeamBuyLeavel, TradeType, TranTeam, TruePrice, UpdateTime, UserID, ZipCode FROM HLShop_Order WHERE (ProductID = @PRODUCTID) AND (Status =0)";
			this._commandCollection[29].CommandType = CommandType.Text;
			this._commandCollection[29].Parameters.Add(new SqlParameter("@PRODUCTID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ProductID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[30] = new SqlCommand();
			this._commandCollection[30].Connection = this.Connection;
			this._commandCollection[30].CommandText = "\r\n                      SELECT     HLShop_Order.Address, HLShop_Order.AfterTime, HLShop_Order.AuctionEndPrice, HLShop_Order.BeginDate, HLShop_Order.BuyerName,\r\n                      HLShop_Order.Charge_Deliver, HLShop_Order.ContacterName, HLShop_Order.DeliverStatus, HLShop_Order.DeliverType,\r\n                      HLShop_Order.Discount_Payment, HLShop_Order.Email, HLShop_Order.EndDate, HLShop_Order.InputTime, HLShop_Order.InvoiceContent,\r\n                      HLShop_Order.Invoiced, HLShop_Order.IsWaitting, HLShop_Order.Mobile, HLShop_Order.MoneyGoods, HLShop_Order.MoneyReceipt,\r\n                      HLShop_Order.MoneyTotal, HLShop_Order.NeedInvoice, HLShop_Order.OnlinePayTradeNo, HLShop_Order.OnlinePayType,\r\n                      HLShop_Order.OrderFormID, HLShop_Order.OrderFormNum, HLShop_Order.PUnit, HLShop_Order.PaymentType, HLShop_Order.Phone,\r\n                      HLShop_Order.PresentExp, HLShop_Order.PresentMoney, HLShop_Order.PresentPoint, HLShop_Order.Price, HLShop_Order.Price_Original,\r\n                      HLShop_Order.ProductID, HLShop_Order.ProductName, HLShop_Order.Quantity, HLShop_Order.RegularBus, HLShop_Order.Remark,\r\n                      HLShop_Order.SalerID, HLShop_Order.SalerName, HLShop_Order.ServiceTerm, HLShop_Order.ShopID, HLShop_Order.Status,\r\n                      HLShop_Order.TeamBuyLeavel, HLShop_Order.TradeType, HLShop_Order.TranTeam, HLShop_Order.UserID, HLShop_Order.UpdateTime,\r\n                      HLShop_Order.ZipCode, HL_UserInfo.ICQ, HL_UserInfo.OICQ, HL_UserInfo.Taobaowangwang, HL_UserInfo.UserInfoID,HLShop_Order.PayStatus\r\n                      FROM         HLShop_Order INNER JOIN\r\n                      HL_UserInfo ON HLShop_Order.UserID = HL_UserInfo.UserID\r\n                      WHERE  (HLShop_Order.TradeType=3) AND  (HLShop_Order.ProductID = @ProductID) AND(HLShop_Order.PayStatus!=0) AND (HLShop_Order.RegularBus <= @RegularBus) AND (HLShop_Order.EndDate>GetDate()) AND (TranTeam<>1) AND (IsWaitting=1)";
			this._commandCollection[30].CommandType = CommandType.Text;
			this._commandCollection[30].Parameters.Add(new SqlParameter("@ProductID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ProductID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[30].Parameters.Add(new SqlParameter("@RegularBus", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "RegularBus", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[31] = new SqlCommand();
			this._commandCollection[31].Connection = this.Connection;
			this._commandCollection[31].CommandText = "SELECT HLShop_Order.ProductID,HLShop_Product.ProductName,\r\nHLSHop_Order.TranTeam,HLSHop_Order.BuyerName,HLSHop_Order.UserID,\r\nHLShop_Order.Quantity,HLShop_Order.TranTeam,\r\nHLShop_Order.OrderFormID,HLShop_Order.OrderFormNum,HLShop_Order.MoneyTotal,\r\nHLShop_Order.InputTime,HLShop_Order.Status,HLShop_Order.MoneyGoods,HLShop_Order.PayStatus,HLShop_Order.MoneyReceipt \r\n   FROM HLShop_Order inner join HLShop_Product On HLShop_Product.ProductID=HLShop_Order.ProductID\r\nWHERE (HLShop_Order.SalerID=@SalerID) AND (HLSHop_Order.ProductID=@ProductID) AND\r\n(HLShop_Order.MoneyReceipt<=0 OR HLShop_Order.PayStatus=0)  AND\r\n(HLShop_Order.TradeType=3) AND\r\n(HLSHop_Order.IsWaitting=1) AND\r\n(DateDiff(s, GetDate(),(DATEADD(hh,2,HLSHop_Order.EndDate)))>0) ";
			this._commandCollection[31].CommandType = CommandType.Text;
			this._commandCollection[31].Parameters.Add(new SqlParameter("@SalerID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "SalerID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[31].Parameters.Add(new SqlParameter("@ProductID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ProductID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[32] = new SqlCommand();
			this._commandCollection[32].Connection = this.Connection;
			this._commandCollection[32].CommandText = "SELECT   'OrderFormID'= CASE WHEN   COUNT(*)  IS NULL THEN 0 ELSE COUNT(*) END\r\nFROM         HLShop_Order\r\nWHERE     (Status=0) AND (TeamBuyLeavel = @TeamBuyLeavel) AND (ProductID = @ProductID) AND (RegularBus = @RegularBus)";
			this._commandCollection[32].CommandType = CommandType.Text;
			this._commandCollection[32].Parameters.Add(new SqlParameter("@TeamBuyLeavel", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "TeamBuyLeavel", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[32].Parameters.Add(new SqlParameter("@ProductID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ProductID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[32].Parameters.Add(new SqlParameter("@RegularBus", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "RegularBus", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[33] = new SqlCommand();
			this._commandCollection[33].Connection = this.Connection;
			this._commandCollection[33].CommandText = "SELECT  'OrderFormID' =CASE WHEN     SUM(Quantity) IS NULL THEN 0  WHEN     SUM(Quantity)='' THEN 0 ELSE    SUM(Quantity) END \r\nFROM         HLShop_Order\r\nWHERE     (ProductID = @productid) AND (RegularBus = @RegularBus) AND (TeamBuyLeavel = @TeamBuyLeavel) ";
			this._commandCollection[33].CommandType = CommandType.Text;
			this._commandCollection[33].Parameters.Add(new SqlParameter("@productid", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ProductID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[33].Parameters.Add(new SqlParameter("@RegularBus", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "RegularBus", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[33].Parameters.Add(new SqlParameter("@TeamBuyLeavel", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "TeamBuyLeavel", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[34] = new SqlCommand();
			this._commandCollection[34].Connection = this.Connection;
			this._commandCollection[34].CommandText = "SELECT   'OrderFormID' =case   when     COUNT(*)  is null then 0 else    COUNT(*) end\r\nFROM         HLShop_Order\r\nWHERE     (ProductID = @ProductID) AND (RegularBus = @RegularBus) AND (UserID = @UserID) AND (TeamBuyLeavel = @TeamBuyLeavel) AND \r\n                      (Status = 0)";
			this._commandCollection[34].CommandType = CommandType.Text;
			this._commandCollection[34].Parameters.Add(new SqlParameter("@ProductID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ProductID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[34].Parameters.Add(new SqlParameter("@RegularBus", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "RegularBus", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[34].Parameters.Add(new SqlParameter("@UserID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "UserID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[34].Parameters.Add(new SqlParameter("@TeamBuyLeavel", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "TeamBuyLeavel", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[35] = new SqlCommand();
			this._commandCollection[35].Connection = this.Connection;
			this._commandCollection[35].CommandText = "PR_DeleteOrder";
			this._commandCollection[35].CommandType = CommandType.StoredProcedure;
			this._commandCollection[35].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[35].Parameters.Add(new SqlParameter("@OrderID", SqlDbType.VarChar, 200, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[36] = new SqlCommand();
			this._commandCollection[36].Connection = this.Connection;
			this._commandCollection[36].CommandText = "PR_AddOrderByAgent";
			this._commandCollection[36].CommandType = CommandType.StoredProcedure;
			this._commandCollection[36].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[36].Parameters.Add(new SqlParameter("@Price_Original", SqlDbType.Decimal, 9, ParameterDirection.Input, 18, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[36].Parameters.Add(new SqlParameter("@UpdateTime", SqlDbType.DateTime, 8, ParameterDirection.Input, 23, 3, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[36].Parameters.Add(new SqlParameter("@Status", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[36].Parameters.Add(new SqlParameter("@OrderFormID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[36].Parameters.Add(new SqlParameter("@ProductID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[37] = new SqlCommand();
			this._commandCollection[37].Connection = this.Connection;
			this._commandCollection[37].CommandText = "UPDATE [HLShop_Order] SET [Status] = 0 \r\n WHERE (([ProductID] = @ProductID) AND ([TradeType]=2) AND ([Status]=0))";
			this._commandCollection[37].CommandType = CommandType.Text;
			this._commandCollection[37].Parameters.Add(new SqlParameter("@ProductID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ProductID", DataRowVersion.Original, false, null, "", "", ""));
			this._commandCollection[38] = new SqlCommand();
			this._commandCollection[38].Connection = this.Connection;
			this._commandCollection[38].CommandText = "UPDATE    HLShop_Product\r\nSET              OrderNum= CASE WHEN HLShop_Product.OrderNum IS NULL THEN 0 ELSE HLShop_Product.OrderNum END + HLShop_Order.Quantity\r\nFROM         HLShop_Order INNER JOIN\r\n                      HLShop_Product ON HLShop_Order.ProductID = HLShop_Product.ProductID\r\nWHERE     (HLShop_Order.OrderFormID = @OrderFormID)";
			this._commandCollection[38].CommandType = CommandType.Text;
			this._commandCollection[38].Parameters.Add(new SqlParameter("@OrderFormID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "OrderFormID", DataRowVersion.Original, false, null, "", "", ""));
			this._commandCollection[39] = new SqlCommand();
			this._commandCollection[39].Connection = this.Connection;
			this._commandCollection[39].CommandText = " \r\nUPDATE    HLShop_Order\r\nSET              hlshop_order.Status = '等待确认'\r\nFROM         HLShop_Order\r\nwhere hlshop_order.status=0      \r\nand  RegularBus=@RegularBus and productid=@productid and TeamBuyLeavel=@TeamBuyLeavel\r\nAND SALERID=@Salerid\r\n ";
			this._commandCollection[39].CommandType = CommandType.Text;
			this._commandCollection[39].Parameters.Add(new SqlParameter("@RegularBus", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "RegularBus", DataRowVersion.Original, false, null, "", "", ""));
			this._commandCollection[39].Parameters.Add(new SqlParameter("@productid", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ProductID", DataRowVersion.Original, false, null, "", "", ""));
			this._commandCollection[39].Parameters.Add(new SqlParameter("@TeamBuyLeavel", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "TeamBuyLeavel", DataRowVersion.Original, false, null, "", "", ""));
			this._commandCollection[39].Parameters.Add(new SqlParameter("@Salerid", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "SalerID", DataRowVersion.Original, false, null, "", "", ""));
			this._commandCollection[40] = new SqlCommand();
			this._commandCollection[40].Connection = this.Connection;
			this._commandCollection[40].CommandText = "UPDATE    HLShop_Order\r\nSET              hlshop_order.Status ='等待确认' \r\nFROM         HLShop_Order INNER JOIN\r\n                      HLShop_Product ON HLShop_Order.ProductID = HLShop_Product.ProductID\r\nwhere hlshop_order.status='领先'  and HLShop_Product.enddate<getdate()  and HLShop_Order.SalerID=@SalerID";
			this._commandCollection[40].CommandType = CommandType.Text;
			this._commandCollection[40].Parameters.Add(new SqlParameter("@SalerID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "SalerID", DataRowVersion.Original, false, null, "", "", ""));
			this._commandCollection[41] = new SqlCommand();
			this._commandCollection[41].Connection = this.Connection;
			this._commandCollection[41].CommandText = "UPDATE [HLShop_Order] SET [MoneyTotal] = @MoneyTotal, [MoneyGoods] = @MoneyGoods*Quantity, [TruePrice]=@MoneyGoods,[Price]=@MoneyGoods, [Status] = @Status,[PayStatus]=@PayStatus ,[TranTeam]=@TranTeam,[IsWaitting]=0,[TeamBuyLeavel]=@TeamBuyLeavel,DeliverStatus='等待发货',UpdateTime=@UpdateTime WHERE (([OrderFormID] = @OrderFormID))";
			this._commandCollection[41].CommandType = CommandType.Text;
			this._commandCollection[41].Parameters.Add(new SqlParameter("@MoneyTotal", SqlDbType.Decimal, 9, ParameterDirection.Input, 19, 2, "MoneyTotal", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[41].Parameters.Add(new SqlParameter("@MoneyGoods", SqlDbType.Decimal, 9, ParameterDirection.Input, 19, 2, "MoneyGoods", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[41].Parameters.Add(new SqlParameter("@Status", SqlDbType.Int, 100, ParameterDirection.Input, 0, 0, "Status", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[41].Parameters.Add(new SqlParameter("@PayStatus", SqlDbType.Int, 50, ParameterDirection.Input, 0, 0, "PayStatus", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[41].Parameters.Add(new SqlParameter("@TranTeam", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "TranTeam", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[41].Parameters.Add(new SqlParameter("@TeamBuyLeavel", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "TeamBuyLeavel", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[41].Parameters.Add(new SqlParameter("@UpdateTime", SqlDbType.DateTime, 8, ParameterDirection.Input, 0, 0, "UpdateTime", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[41].Parameters.Add(new SqlParameter("@OrderFormID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "OrderFormID", DataRowVersion.Original, false, null, "", "", ""));
		}
		[DataObjectMethod(DataObjectMethodType.Select, true), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Order.HLShop_OrderDataTable GetAllOrders()
		{
			this.Adapter.SelectCommand = this.CommandCollection[0];
			S_Order.HLShop_OrderDataTable hLShop_OrderDataTable = new S_Order.HLShop_OrderDataTable();
			this.Adapter.Fill(hLShop_OrderDataTable);
			return hLShop_OrderDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Order.HLShop_OrderDataTable GetAdminOrders(string tblName, string strGetFields, string fldName, int? PageSize, int? PageIndex, int? OrderType, string strWhere, int? Counts)
		{
			this.Adapter.SelectCommand = this.CommandCollection[2];
			if (tblName == null)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = tblName;
			}
			if (strGetFields == null)
			{
				this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[2].Value = strGetFields;
			}
			if (fldName == null)
			{
				this.Adapter.SelectCommand.Parameters[3].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[3].Value = fldName;
			}
			if (PageSize.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[4].Value = PageSize.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[4].Value = System.DBNull.Value;
			}
			if (PageIndex.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[5].Value = PageIndex.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[5].Value = System.DBNull.Value;
			}
			if (OrderType.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[6].Value = OrderType.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[6].Value = System.DBNull.Value;
			}
			if (strWhere == null)
			{
				this.Adapter.SelectCommand.Parameters[7].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[7].Value = strWhere;
			}
			if (Counts.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[8].Value = Counts.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[8].Value = System.DBNull.Value;
			}
			S_Order.HLShop_OrderDataTable hLShop_OrderDataTable = new S_Order.HLShop_OrderDataTable();
			this.Adapter.Fill(hLShop_OrderDataTable);
			return hLShop_OrderDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Order.HLShop_OrderDataTable GetMAxAuctionPriceUserIDbyProductID(int? ProductID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[4];
			if (ProductID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = ProductID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			S_Order.HLShop_OrderDataTable hLShop_OrderDataTable = new S_Order.HLShop_OrderDataTable();
			this.Adapter.Fill(hLShop_OrderDataTable);
			return hLShop_OrderDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Order.HLShop_OrderDataTable GetMaxRegularBusOrder(int? productid, int? TeamBuyLeavel)
		{
			this.Adapter.SelectCommand = this.CommandCollection[5];
			if (productid.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = productid.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			if (TeamBuyLeavel.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = TeamBuyLeavel.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			S_Order.HLShop_OrderDataTable hLShop_OrderDataTable = new S_Order.HLShop_OrderDataTable();
			this.Adapter.Fill(hLShop_OrderDataTable);
			return hLShop_OrderDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Order.HLShop_OrderDataTable GetMyAuctionProduct(int? UserID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[6];
			if (UserID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = UserID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			S_Order.HLShop_OrderDataTable hLShop_OrderDataTable = new S_Order.HLShop_OrderDataTable();
			this.Adapter.Fill(hLShop_OrderDataTable);
			return hLShop_OrderDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Order.HLShop_OrderDataTable GetOrderByManyCondition(int? UserIDSalerID, string Moment, string BeginDate, string EndDate, string OrderFormNum, int? BeginOrderID, int? EndOrderID, decimal? BeginMoney, decimal? EndMoney, int? Status, int? PayStatic, int? DeliverStatus, string UserName, string ContacterName, string Email, string Address, string Phone, string Mobile, string Remark, string ProductName, string TransSize)
		{
			this.Adapter.SelectCommand = this.CommandCollection[8];
			if (UserIDSalerID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = UserIDSalerID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			if (Moment == null)
			{
				this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[2].Value = Moment;
			}
			if (BeginDate == null)
			{
				this.Adapter.SelectCommand.Parameters[3].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[3].Value = BeginDate;
			}
			if (EndDate == null)
			{
				this.Adapter.SelectCommand.Parameters[4].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[4].Value = EndDate;
			}
			if (OrderFormNum == null)
			{
				this.Adapter.SelectCommand.Parameters[5].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[5].Value = OrderFormNum;
			}
			if (BeginOrderID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[6].Value = BeginOrderID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[6].Value = System.DBNull.Value;
			}
			if (EndOrderID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[7].Value = EndOrderID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[7].Value = System.DBNull.Value;
			}
			if (BeginMoney.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[8].Value = BeginMoney.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[8].Value = System.DBNull.Value;
			}
			if (EndMoney.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[9].Value = EndMoney.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[9].Value = System.DBNull.Value;
			}
			if (Status.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[10].Value = Status.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[10].Value = System.DBNull.Value;
			}
			if (PayStatic.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[11].Value = PayStatic.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[11].Value = System.DBNull.Value;
			}
			if (DeliverStatus.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[12].Value = DeliverStatus.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[12].Value = System.DBNull.Value;
			}
			if (UserName == null)
			{
				this.Adapter.SelectCommand.Parameters[13].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[13].Value = UserName;
			}
			if (ContacterName == null)
			{
				this.Adapter.SelectCommand.Parameters[14].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[14].Value = ContacterName;
			}
			if (Email == null)
			{
				this.Adapter.SelectCommand.Parameters[15].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[15].Value = Email;
			}
			if (Address == null)
			{
				this.Adapter.SelectCommand.Parameters[16].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[16].Value = Address;
			}
			if (Phone == null)
			{
				this.Adapter.SelectCommand.Parameters[17].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[17].Value = Phone;
			}
			if (Mobile == null)
			{
				this.Adapter.SelectCommand.Parameters[18].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[18].Value = Mobile;
			}
			if (Remark == null)
			{
				this.Adapter.SelectCommand.Parameters[19].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[19].Value = Remark;
			}
			if (ProductName == null)
			{
				this.Adapter.SelectCommand.Parameters[20].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[20].Value = ProductName;
			}
			if (TransSize == null)
			{
				this.Adapter.SelectCommand.Parameters[21].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[21].Value = TransSize;
			}
			S_Order.HLShop_OrderDataTable hLShop_OrderDataTable = new S_Order.HLShop_OrderDataTable();
			this.Adapter.Fill(hLShop_OrderDataTable);
			return hLShop_OrderDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Order.HLShop_OrderDataTable GetOrderByOrderFormNum(string OrderFormNum)
		{
			this.Adapter.SelectCommand = this.CommandCollection[9];
			if (OrderFormNum == null)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = OrderFormNum;
			}
			S_Order.HLShop_OrderDataTable hLShop_OrderDataTable = new S_Order.HLShop_OrderDataTable();
			this.Adapter.Fill(hLShop_OrderDataTable);
			return hLShop_OrderDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Order.HLShop_OrderDataTable GetOrderByOrderID(int OrderFormID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[10];
			this.Adapter.SelectCommand.Parameters[0].Value = OrderFormID;
			S_Order.HLShop_OrderDataTable hLShop_OrderDataTable = new S_Order.HLShop_OrderDataTable();
			this.Adapter.Fill(hLShop_OrderDataTable);
			return hLShop_OrderDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Order.HLShop_OrderDataTable GetOrderQuantityByProductid(int? productid)
		{
			this.Adapter.SelectCommand = this.CommandCollection[11];
			if (productid.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = productid.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			S_Order.HLShop_OrderDataTable hLShop_OrderDataTable = new S_Order.HLShop_OrderDataTable();
			this.Adapter.Fill(hLShop_OrderDataTable);
			return hLShop_OrderDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Order.HLShop_OrderDataTable GetOtherTeamOrder(int? productid, int? TeamBuyLeavel, int OrderFormID, int? RegularBus)
		{
			this.Adapter.SelectCommand = this.CommandCollection[12];
			if (productid.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = productid.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			if (TeamBuyLeavel.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = TeamBuyLeavel.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			this.Adapter.SelectCommand.Parameters[2].Value = OrderFormID;
			if (RegularBus.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[3].Value = RegularBus.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[3].Value = System.DBNull.Value;
			}
			S_Order.HLShop_OrderDataTable hLShop_OrderDataTable = new S_Order.HLShop_OrderDataTable();
			this.Adapter.Fill(hLShop_OrderDataTable);
			return hLShop_OrderDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Order.HLShop_OrderDataTable GetProductByUserIDProductID(int? UserID, int? ProductID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[13];
			if (UserID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = UserID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			if (ProductID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = ProductID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			S_Order.HLShop_OrderDataTable hLShop_OrderDataTable = new S_Order.HLShop_OrderDataTable();
			this.Adapter.Fill(hLShop_OrderDataTable);
			return hLShop_OrderDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Order.HLShop_OrderDataTable GetProductSaleOrderByProductID(string tblName, string strGetFields, string fldName, int? PageSize, int? PageIndex, int? OrderType, string strWhere, int? Counts)
		{
			this.Adapter.SelectCommand = this.CommandCollection[14];
			if (tblName == null)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = tblName;
			}
			if (strGetFields == null)
			{
				this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[2].Value = strGetFields;
			}
			if (fldName == null)
			{
				this.Adapter.SelectCommand.Parameters[3].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[3].Value = fldName;
			}
			if (PageSize.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[4].Value = PageSize.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[4].Value = System.DBNull.Value;
			}
			if (PageIndex.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[5].Value = PageIndex.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[5].Value = System.DBNull.Value;
			}
			if (OrderType.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[6].Value = OrderType.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[6].Value = System.DBNull.Value;
			}
			if (strWhere == null)
			{
				this.Adapter.SelectCommand.Parameters[7].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[7].Value = strWhere;
			}
			if (Counts.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[8].Value = Counts.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[8].Value = System.DBNull.Value;
			}
			S_Order.HLShop_OrderDataTable hLShop_OrderDataTable = new S_Order.HLShop_OrderDataTable();
			this.Adapter.Fill(hLShop_OrderDataTable);
			return hLShop_OrderDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Order.HLShop_OrderDataTable GetSaleCount(int? SalerID, string productname, string Monents, string BeginDate, string EndDate)
		{
			this.Adapter.SelectCommand = this.CommandCollection[15];
			if (SalerID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = SalerID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			if (productname == null)
			{
				this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[2].Value = productname;
			}
			if (Monents == null)
			{
				this.Adapter.SelectCommand.Parameters[3].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[3].Value = Monents;
			}
			if (BeginDate == null)
			{
				this.Adapter.SelectCommand.Parameters[4].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[4].Value = BeginDate;
			}
			if (EndDate == null)
			{
				this.Adapter.SelectCommand.Parameters[5].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[5].Value = EndDate;
			}
			S_Order.HLShop_OrderDataTable hLShop_OrderDataTable = new S_Order.HLShop_OrderDataTable();
			this.Adapter.Fill(hLShop_OrderDataTable);
			return hLShop_OrderDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Order.HLShop_OrderDataTable GetSaleItem(int? SalerID, string productname, string Monents, string BeginDate, string EndDate, string UserName)
		{
			this.Adapter.SelectCommand = this.CommandCollection[16];
			if (SalerID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = SalerID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			if (productname == null)
			{
				this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[2].Value = productname;
			}
			if (Monents == null)
			{
				this.Adapter.SelectCommand.Parameters[3].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[3].Value = Monents;
			}
			if (BeginDate == null)
			{
				this.Adapter.SelectCommand.Parameters[4].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[4].Value = BeginDate;
			}
			if (EndDate == null)
			{
				this.Adapter.SelectCommand.Parameters[5].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[5].Value = EndDate;
			}
			if (UserName == null)
			{
				this.Adapter.SelectCommand.Parameters[6].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[6].Value = UserName;
			}
			S_Order.HLShop_OrderDataTable hLShop_OrderDataTable = new S_Order.HLShop_OrderDataTable();
			this.Adapter.Fill(hLShop_OrderDataTable);
			return hLShop_OrderDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Order.HLShop_OrderDataTable GetSaleProductItem(int? ProductID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[17];
			if (ProductID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = ProductID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			S_Order.HLShop_OrderDataTable hLShop_OrderDataTable = new S_Order.HLShop_OrderDataTable();
			this.Adapter.Fill(hLShop_OrderDataTable);
			return hLShop_OrderDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Order.HLShop_OrderDataTable GetSalerAuctionProduct(int? UserID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[18];
			if (UserID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = UserID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			S_Order.HLShop_OrderDataTable hLShop_OrderDataTable = new S_Order.HLShop_OrderDataTable();
			this.Adapter.Fill(hLShop_OrderDataTable);
			return hLShop_OrderDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Order.HLShop_OrderDataTable GetSampleOrderBySalerIDTradeType(int? SalerID, string TradeType)
		{
			this.Adapter.SelectCommand = this.CommandCollection[19];
			if (SalerID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = SalerID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			if (TradeType == null)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = TradeType;
			}
			S_Order.HLShop_OrderDataTable hLShop_OrderDataTable = new S_Order.HLShop_OrderDataTable();
			this.Adapter.Fill(hLShop_OrderDataTable);
			return hLShop_OrderDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Order.HLShop_OrderDataTable GetSampleOrderByUserIDByTradeType(int? UserID, string TradeType)
		{
			this.Adapter.SelectCommand = this.CommandCollection[20];
			if (UserID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = UserID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			if (TradeType == null)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = TradeType;
			}
			S_Order.HLShop_OrderDataTable hLShop_OrderDataTable = new S_Order.HLShop_OrderDataTable();
			this.Adapter.Fill(hLShop_OrderDataTable);
			return hLShop_OrderDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Order.HLShop_OrderDataTable GetTeamBuyLeavelByProductID(int? ProductID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[22];
			if (ProductID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = ProductID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			S_Order.HLShop_OrderDataTable hLShop_OrderDataTable = new S_Order.HLShop_OrderDataTable();
			this.Adapter.Fill(hLShop_OrderDataTable);
			return hLShop_OrderDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Order.HLShop_OrderDataTable GetTeamBuyOrderBySalerIDStatusIsWaitting(int? SalerID, string Status, bool? IsWaitting)
		{
			this.Adapter.SelectCommand = this.CommandCollection[24];
			if (SalerID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = SalerID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			if (Status == null)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = Status;
			}
			if (IsWaitting.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[2].Value = IsWaitting.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
			}
			S_Order.HLShop_OrderDataTable hLShop_OrderDataTable = new S_Order.HLShop_OrderDataTable();
			this.Adapter.Fill(hLShop_OrderDataTable);
			return hLShop_OrderDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Order.HLShop_OrderDataTable GetTeamBuyOrderByUserID(int? UserID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[25];
			if (UserID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = UserID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			S_Order.HLShop_OrderDataTable hLShop_OrderDataTable = new S_Order.HLShop_OrderDataTable();
			this.Adapter.Fill(hLShop_OrderDataTable);
			return hLShop_OrderDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Order.HLShop_OrderDataTable GetTeamBuyOrderListBySalerID(int? SalerID, int? ProductID, int? TranTeam, int? TeamBuyLeavel)
		{
			this.Adapter.SelectCommand = this.CommandCollection[26];
			if (SalerID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = SalerID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			if (ProductID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = ProductID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			if (TranTeam.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[2].Value = TranTeam.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
			}
			if (TeamBuyLeavel.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[3].Value = TeamBuyLeavel.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[3].Value = System.DBNull.Value;
			}
			S_Order.HLShop_OrderDataTable hLShop_OrderDataTable = new S_Order.HLShop_OrderDataTable();
			this.Adapter.Fill(hLShop_OrderDataTable);
			return hLShop_OrderDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Order.HLShop_OrderDataTable GetTeamingOrder(int? salerID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[27];
			if (salerID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = salerID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			S_Order.HLShop_OrderDataTable hLShop_OrderDataTable = new S_Order.HLShop_OrderDataTable();
			this.Adapter.Fill(hLShop_OrderDataTable);
			return hLShop_OrderDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Order.HLShop_OrderDataTable GetTeamingOrdersByProductID(int? Productid)
		{
			this.Adapter.SelectCommand = this.CommandCollection[28];
			if (Productid.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = Productid.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			S_Order.HLShop_OrderDataTable hLShop_OrderDataTable = new S_Order.HLShop_OrderDataTable();
			this.Adapter.Fill(hLShop_OrderDataTable);
			return hLShop_OrderDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Order.HLShop_OrderDataTable GetTeamingUser(int? PRODUCTID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[29];
			if (PRODUCTID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = PRODUCTID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			S_Order.HLShop_OrderDataTable hLShop_OrderDataTable = new S_Order.HLShop_OrderDataTable();
			this.Adapter.Fill(hLShop_OrderDataTable);
			return hLShop_OrderDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Order.HLShop_OrderDataTable GetTeamMember(int? ProductID, int? RegularBus)
		{
			this.Adapter.SelectCommand = this.CommandCollection[30];
			if (ProductID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = ProductID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			if (RegularBus.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = RegularBus.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			S_Order.HLShop_OrderDataTable hLShop_OrderDataTable = new S_Order.HLShop_OrderDataTable();
			this.Adapter.Fill(hLShop_OrderDataTable);
			return hLShop_OrderDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Order.HLShop_OrderDataTable GetTeamNotPayOrderList(int? SalerID, int? ProductID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[31];
			if (SalerID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = SalerID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			if (ProductID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = ProductID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			S_Order.HLShop_OrderDataTable hLShop_OrderDataTable = new S_Order.HLShop_OrderDataTable();
			this.Adapter.Fill(hLShop_OrderDataTable);
			return hLShop_OrderDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Order.HLShop_OrderDataTable GetTeamOrderCount(int? TeamBuyLeavel, int? ProductID, int? RegularBus)
		{
			this.Adapter.SelectCommand = this.CommandCollection[32];
			if (TeamBuyLeavel.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = TeamBuyLeavel.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			if (ProductID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = ProductID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			if (RegularBus.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[2].Value = RegularBus.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
			}
			S_Order.HLShop_OrderDataTable hLShop_OrderDataTable = new S_Order.HLShop_OrderDataTable();
			this.Adapter.Fill(hLShop_OrderDataTable);
			return hLShop_OrderDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Order.HLShop_OrderDataTable GetTeamProductCount(int? productid, int? RegularBus, int? TeamBuyLeavel)
		{
			this.Adapter.SelectCommand = this.CommandCollection[33];
			if (productid.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = productid.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			if (RegularBus.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = RegularBus.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			if (TeamBuyLeavel.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[2].Value = TeamBuyLeavel.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
			}
			S_Order.HLShop_OrderDataTable hLShop_OrderDataTable = new S_Order.HLShop_OrderDataTable();
			this.Adapter.Fill(hLShop_OrderDataTable);
			return hLShop_OrderDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual S_Order.HLShop_OrderDataTable JoinTeam(int? ProductID, int? RegularBus, int? UserID, int? TeamBuyLeavel)
		{
			this.Adapter.SelectCommand = this.CommandCollection[34];
			if (ProductID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = ProductID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			if (RegularBus.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = RegularBus.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			if (UserID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[2].Value = UserID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
			}
			if (TeamBuyLeavel.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[3].Value = TeamBuyLeavel.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[3].Value = System.DBNull.Value;
			}
			S_Order.HLShop_OrderDataTable hLShop_OrderDataTable = new S_Order.HLShop_OrderDataTable();
			this.Adapter.Fill(hLShop_OrderDataTable);
			return hLShop_OrderDataTable;
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(S_Order.HLShop_OrderDataTable dataTable)
		{
			return this.Adapter.Update(dataTable);
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(S_Order dataSet)
		{
			return this.Adapter.Update(dataSet, "HLShop_Order");
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(DataRow dataRow)
		{
			return this.Adapter.Update(new DataRow[]
			{
				dataRow
			});
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(DataRow[] dataRows)
		{
			return this.Adapter.Update(dataRows);
		}
		[DataObjectMethod(DataObjectMethodType.Delete, true), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Delete(int Original_OrderFormID)
		{
			this.Adapter.DeleteCommand.Parameters[0].Value = Original_OrderFormID;
			ConnectionState state = this.Adapter.DeleteCommand.Connection.State;
			if ((this.Adapter.DeleteCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				this.Adapter.DeleteCommand.Connection.Open();
			}
			int result;
			try
			{
				int num = this.Adapter.DeleteCommand.ExecuteNonQuery();
				result = num;
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					this.Adapter.DeleteCommand.Connection.Close();
				}
			}
			return result;
		}
		[DataObjectMethod(DataObjectMethodType.Insert, true), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Insert(string OrderFormNum, int? TradeType, int? UserID, string BuyerName, int? ShopID, int? ProductID, string ProductName, int? SalerID, System.DateTime? InputTime, System.DateTime? UpdateTime, string ContacterName, System.DateTime? BeginDate, decimal? MoneyReceipt, string Remark, decimal? MoneyGoods, decimal? MoneyTotal, string SalerName, decimal? OrderMoneyRate, string HiddenInfo, int? RegularBus, int? TranTeam, int? AfterTime, bool? IsWaitting, int? TeamBuyLeavel, decimal? TruePrice, int? ServiceTerm, decimal? Price_Original, decimal? Price, string PUnit, bool? NeedInvoice, bool? Invoiced, string InvoiceContent, int? SalerReview, int? BuyerReview, string OnlinePayTradeNo, string OnlinePayType, System.DateTime? EndDate, decimal? AuctionEndPrice, int? Quantity, string Deliver_PaymentType, decimal? Charge_Deliver, decimal? Discount_Payment, int? PresentPoint, int? PresentExp, decimal? PresentMoney, int? PayStatus, int? DeliverStatus, int? Status, int? DeliverType, int? PaymentType, string Email, string Phone, string Mobile, int? ZipCode, string Address)
		{
			if (OrderFormNum == null)
			{
				this.Adapter.InsertCommand.Parameters[0].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[0].Value = OrderFormNum;
			}
			if (TradeType.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[1].Value = TradeType.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[1].Value = System.DBNull.Value;
			}
			if (UserID.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[2].Value = UserID.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[2].Value = System.DBNull.Value;
			}
			if (BuyerName == null)
			{
				this.Adapter.InsertCommand.Parameters[3].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[3].Value = BuyerName;
			}
			if (ShopID.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[4].Value = ShopID.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[4].Value = System.DBNull.Value;
			}
			if (ProductID.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[5].Value = ProductID.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[5].Value = System.DBNull.Value;
			}
			if (ProductName == null)
			{
				this.Adapter.InsertCommand.Parameters[6].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[6].Value = ProductName;
			}
			if (SalerID.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[7].Value = SalerID.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[7].Value = System.DBNull.Value;
			}
			if (InputTime.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[8].Value = InputTime.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[8].Value = System.DBNull.Value;
			}
			if (UpdateTime.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[9].Value = UpdateTime.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[9].Value = System.DBNull.Value;
			}
			if (ContacterName == null)
			{
				this.Adapter.InsertCommand.Parameters[10].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[10].Value = ContacterName;
			}
			if (BeginDate.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[11].Value = BeginDate.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[11].Value = System.DBNull.Value;
			}
			if (MoneyReceipt.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[12].Value = MoneyReceipt.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[12].Value = System.DBNull.Value;
			}
			if (Remark == null)
			{
				this.Adapter.InsertCommand.Parameters[13].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[13].Value = Remark;
			}
			if (MoneyGoods.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[14].Value = MoneyGoods.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[14].Value = System.DBNull.Value;
			}
			if (MoneyTotal.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[15].Value = MoneyTotal.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[15].Value = System.DBNull.Value;
			}
			if (SalerName == null)
			{
				this.Adapter.InsertCommand.Parameters[16].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[16].Value = SalerName;
			}
			if (OrderMoneyRate.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[17].Value = OrderMoneyRate.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[17].Value = System.DBNull.Value;
			}
			if (HiddenInfo == null)
			{
				this.Adapter.InsertCommand.Parameters[18].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[18].Value = HiddenInfo;
			}
			if (RegularBus.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[19].Value = RegularBus.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[19].Value = System.DBNull.Value;
			}
			if (TranTeam.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[20].Value = TranTeam.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[20].Value = System.DBNull.Value;
			}
			if (AfterTime.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[21].Value = AfterTime.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[21].Value = System.DBNull.Value;
			}
			if (IsWaitting.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[22].Value = IsWaitting.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[22].Value = System.DBNull.Value;
			}
			if (TeamBuyLeavel.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[23].Value = TeamBuyLeavel.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[23].Value = System.DBNull.Value;
			}
			if (TruePrice.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[24].Value = TruePrice.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[24].Value = System.DBNull.Value;
			}
			if (ServiceTerm.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[25].Value = ServiceTerm.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[25].Value = System.DBNull.Value;
			}
			if (Price_Original.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[26].Value = Price_Original.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[26].Value = System.DBNull.Value;
			}
			if (Price.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[27].Value = Price.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[27].Value = System.DBNull.Value;
			}
			if (PUnit == null)
			{
				this.Adapter.InsertCommand.Parameters[28].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[28].Value = PUnit;
			}
			if (NeedInvoice.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[29].Value = NeedInvoice.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[29].Value = System.DBNull.Value;
			}
			if (Invoiced.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[30].Value = Invoiced.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[30].Value = System.DBNull.Value;
			}
			if (InvoiceContent == null)
			{
				this.Adapter.InsertCommand.Parameters[31].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[31].Value = InvoiceContent;
			}
			if (SalerReview.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[32].Value = SalerReview.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[32].Value = System.DBNull.Value;
			}
			if (BuyerReview.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[33].Value = BuyerReview.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[33].Value = System.DBNull.Value;
			}
			if (OnlinePayTradeNo == null)
			{
				this.Adapter.InsertCommand.Parameters[34].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[34].Value = OnlinePayTradeNo;
			}
			if (OnlinePayType == null)
			{
				this.Adapter.InsertCommand.Parameters[35].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[35].Value = OnlinePayType;
			}
			if (EndDate.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[36].Value = EndDate.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[36].Value = System.DBNull.Value;
			}
			if (AuctionEndPrice.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[37].Value = AuctionEndPrice.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[37].Value = System.DBNull.Value;
			}
			if (Quantity.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[38].Value = Quantity.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[38].Value = System.DBNull.Value;
			}
			if (Deliver_PaymentType == null)
			{
				this.Adapter.InsertCommand.Parameters[39].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[39].Value = Deliver_PaymentType;
			}
			if (Charge_Deliver.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[40].Value = Charge_Deliver.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[40].Value = System.DBNull.Value;
			}
			if (Discount_Payment.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[41].Value = Discount_Payment.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[41].Value = System.DBNull.Value;
			}
			if (PresentPoint.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[42].Value = PresentPoint.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[42].Value = System.DBNull.Value;
			}
			if (PresentExp.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[43].Value = PresentExp.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[43].Value = System.DBNull.Value;
			}
			if (PresentMoney.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[44].Value = PresentMoney.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[44].Value = System.DBNull.Value;
			}
			if (PayStatus.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[45].Value = PayStatus.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[45].Value = System.DBNull.Value;
			}
			if (DeliverStatus.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[46].Value = DeliverStatus.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[46].Value = System.DBNull.Value;
			}
			if (Status.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[47].Value = Status.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[47].Value = System.DBNull.Value;
			}
			if (DeliverType.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[48].Value = DeliverType.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[48].Value = System.DBNull.Value;
			}
			if (PaymentType.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[49].Value = PaymentType.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[49].Value = System.DBNull.Value;
			}
			if (Email == null)
			{
				this.Adapter.InsertCommand.Parameters[50].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[50].Value = Email;
			}
			if (Phone == null)
			{
				this.Adapter.InsertCommand.Parameters[51].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[51].Value = Phone;
			}
			if (Mobile == null)
			{
				this.Adapter.InsertCommand.Parameters[52].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[52].Value = Mobile;
			}
			if (ZipCode.HasValue)
			{
				this.Adapter.InsertCommand.Parameters[53].Value = ZipCode.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[53].Value = System.DBNull.Value;
			}
			if (Address == null)
			{
				this.Adapter.InsertCommand.Parameters[54].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.InsertCommand.Parameters[54].Value = Address;
			}
			ConnectionState state = this.Adapter.InsertCommand.Connection.State;
			if ((this.Adapter.InsertCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				this.Adapter.InsertCommand.Connection.Open();
			}
			int result;
			try
			{
				int num = this.Adapter.InsertCommand.ExecuteNonQuery();
				result = num;
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					this.Adapter.InsertCommand.Connection.Close();
				}
			}
			return result;
		}
		[DataObjectMethod(DataObjectMethodType.Update, true), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(string OrderFormNum, int? TradeType, int? UserID, string BuyerName, int? ShopID, int? ProductID, string ProductName, int? SalerID, System.DateTime? InputTime, System.DateTime? UpdateTime, string ContacterName, System.DateTime? BeginDate, decimal? MoneyReceipt, string Remark, decimal? MoneyGoods, decimal? MoneyTotal, string SalerName, decimal? OrderMoneyRate, string HiddenInfo, int? RegularBus, int? TranTeam, int? AfterTime, bool? IsWaitting, int? TeamBuyLeavel, decimal? TruePrice, int? ServiceTerm, decimal? Price_Original, decimal? Price, string PUnit, bool? NeedInvoice, bool? Invoiced, string InvoiceContent, int? SalerReview, int? BuyerReview, string OnlinePayTradeNo, string OnlinePayType, System.DateTime? EndDate, decimal? AuctionEndPrice, int? Quantity, string Deliver_PaymentType, decimal? Charge_Deliver, decimal? Discount_Payment, int? PresentPoint, int? PresentExp, decimal? PresentMoney, int? PayStatus, int? DeliverStatus, int? Status, int? DeliverType, int? PaymentType, string Email, string Phone, string Mobile, int? ZipCode, string Address, int Original_OrderFormID)
		{
			if (OrderFormNum == null)
			{
				this.Adapter.UpdateCommand.Parameters[0].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[0].Value = OrderFormNum;
			}
			if (TradeType.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[1].Value = TradeType.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[1].Value = System.DBNull.Value;
			}
			if (UserID.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[2].Value = UserID.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[2].Value = System.DBNull.Value;
			}
			if (BuyerName == null)
			{
				this.Adapter.UpdateCommand.Parameters[3].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[3].Value = BuyerName;
			}
			if (ShopID.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[4].Value = ShopID.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[4].Value = System.DBNull.Value;
			}
			if (ProductID.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[5].Value = ProductID.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[5].Value = System.DBNull.Value;
			}
			if (ProductName == null)
			{
				this.Adapter.UpdateCommand.Parameters[6].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[6].Value = ProductName;
			}
			if (SalerID.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[7].Value = SalerID.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[7].Value = System.DBNull.Value;
			}
			if (InputTime.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[8].Value = InputTime.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[8].Value = System.DBNull.Value;
			}
			if (UpdateTime.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[9].Value = UpdateTime.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[9].Value = System.DBNull.Value;
			}
			if (ContacterName == null)
			{
				this.Adapter.UpdateCommand.Parameters[10].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[10].Value = ContacterName;
			}
			if (BeginDate.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[11].Value = BeginDate.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[11].Value = System.DBNull.Value;
			}
			if (MoneyReceipt.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[12].Value = MoneyReceipt.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[12].Value = System.DBNull.Value;
			}
			if (Remark == null)
			{
				this.Adapter.UpdateCommand.Parameters[13].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[13].Value = Remark;
			}
			if (MoneyGoods.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[14].Value = MoneyGoods.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[14].Value = System.DBNull.Value;
			}
			if (MoneyTotal.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[15].Value = MoneyTotal.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[15].Value = System.DBNull.Value;
			}
			if (SalerName == null)
			{
				this.Adapter.UpdateCommand.Parameters[16].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[16].Value = SalerName;
			}
			if (OrderMoneyRate.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[17].Value = OrderMoneyRate.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[17].Value = System.DBNull.Value;
			}
			if (HiddenInfo == null)
			{
				this.Adapter.UpdateCommand.Parameters[18].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[18].Value = HiddenInfo;
			}
			if (RegularBus.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[19].Value = RegularBus.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[19].Value = System.DBNull.Value;
			}
			if (TranTeam.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[20].Value = TranTeam.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[20].Value = System.DBNull.Value;
			}
			if (AfterTime.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[21].Value = AfterTime.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[21].Value = System.DBNull.Value;
			}
			if (IsWaitting.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[22].Value = IsWaitting.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[22].Value = System.DBNull.Value;
			}
			if (TeamBuyLeavel.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[23].Value = TeamBuyLeavel.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[23].Value = System.DBNull.Value;
			}
			if (TruePrice.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[24].Value = TruePrice.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[24].Value = System.DBNull.Value;
			}
			if (ServiceTerm.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[25].Value = ServiceTerm.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[25].Value = System.DBNull.Value;
			}
			if (Price_Original.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[26].Value = Price_Original.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[26].Value = System.DBNull.Value;
			}
			if (Price.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[27].Value = Price.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[27].Value = System.DBNull.Value;
			}
			if (PUnit == null)
			{
				this.Adapter.UpdateCommand.Parameters[28].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[28].Value = PUnit;
			}
			if (NeedInvoice.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[29].Value = NeedInvoice.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[29].Value = System.DBNull.Value;
			}
			if (Invoiced.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[30].Value = Invoiced.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[30].Value = System.DBNull.Value;
			}
			if (InvoiceContent == null)
			{
				this.Adapter.UpdateCommand.Parameters[31].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[31].Value = InvoiceContent;
			}
			if (SalerReview.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[32].Value = SalerReview.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[32].Value = System.DBNull.Value;
			}
			if (BuyerReview.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[33].Value = BuyerReview.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[33].Value = System.DBNull.Value;
			}
			if (OnlinePayTradeNo == null)
			{
				this.Adapter.UpdateCommand.Parameters[34].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[34].Value = OnlinePayTradeNo;
			}
			if (OnlinePayType == null)
			{
				this.Adapter.UpdateCommand.Parameters[35].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[35].Value = OnlinePayType;
			}
			if (EndDate.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[36].Value = EndDate.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[36].Value = System.DBNull.Value;
			}
			if (AuctionEndPrice.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[37].Value = AuctionEndPrice.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[37].Value = System.DBNull.Value;
			}
			if (Quantity.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[38].Value = Quantity.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[38].Value = System.DBNull.Value;
			}
			if (Deliver_PaymentType == null)
			{
				this.Adapter.UpdateCommand.Parameters[39].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[39].Value = Deliver_PaymentType;
			}
			if (Charge_Deliver.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[40].Value = Charge_Deliver.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[40].Value = System.DBNull.Value;
			}
			if (Discount_Payment.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[41].Value = Discount_Payment.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[41].Value = System.DBNull.Value;
			}
			if (PresentPoint.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[42].Value = PresentPoint.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[42].Value = System.DBNull.Value;
			}
			if (PresentExp.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[43].Value = PresentExp.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[43].Value = System.DBNull.Value;
			}
			if (PresentMoney.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[44].Value = PresentMoney.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[44].Value = System.DBNull.Value;
			}
			if (PayStatus.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[45].Value = PayStatus.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[45].Value = System.DBNull.Value;
			}
			if (DeliverStatus.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[46].Value = DeliverStatus.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[46].Value = System.DBNull.Value;
			}
			if (Status.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[47].Value = Status.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[47].Value = System.DBNull.Value;
			}
			if (DeliverType.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[48].Value = DeliverType.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[48].Value = System.DBNull.Value;
			}
			if (PaymentType.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[49].Value = PaymentType.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[49].Value = System.DBNull.Value;
			}
			if (Email == null)
			{
				this.Adapter.UpdateCommand.Parameters[50].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[50].Value = Email;
			}
			if (Phone == null)
			{
				this.Adapter.UpdateCommand.Parameters[51].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[51].Value = Phone;
			}
			if (Mobile == null)
			{
				this.Adapter.UpdateCommand.Parameters[52].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[52].Value = Mobile;
			}
			if (ZipCode.HasValue)
			{
				this.Adapter.UpdateCommand.Parameters[53].Value = ZipCode.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[53].Value = System.DBNull.Value;
			}
			if (Address == null)
			{
				this.Adapter.UpdateCommand.Parameters[54].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.UpdateCommand.Parameters[54].Value = Address;
			}
			this.Adapter.UpdateCommand.Parameters[55].Value = Original_OrderFormID;
			ConnectionState state = this.Adapter.UpdateCommand.Connection.State;
			if ((this.Adapter.UpdateCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				this.Adapter.UpdateCommand.Connection.Open();
			}
			int result;
			try
			{
				int num = this.Adapter.UpdateCommand.ExecuteNonQuery();
				result = num;
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					this.Adapter.UpdateCommand.Connection.Close();
				}
			}
			return result;
		}
		[DataObjectMethod(DataObjectMethodType.Delete, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int DeleteTeamingOrder(int? userid, int? productid)
		{
			SqlCommand sqlCommand = this.CommandCollection[1];
			if (userid.HasValue)
			{
				sqlCommand.Parameters[0].Value = userid.Value;
			}
			else
			{
				sqlCommand.Parameters[0].Value = System.DBNull.Value;
			}
			if (productid.HasValue)
			{
				sqlCommand.Parameters[1].Value = productid.Value;
			}
			else
			{
				sqlCommand.Parameters[1].Value = System.DBNull.Value;
			}
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual object GetCurrentBuyNumsByProductID(int? ProductID)
		{
			SqlCommand sqlCommand = this.CommandCollection[3];
			if (ProductID.HasValue)
			{
				sqlCommand.Parameters[0].Value = ProductID.Value;
			}
			else
			{
				sqlCommand.Parameters[0].Value = System.DBNull.Value;
			}
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			object obj;
			try
			{
				obj = sqlCommand.ExecuteScalar();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			object result;
			if (obj == null || obj.GetType() == typeof(System.DBNull))
			{
				result = null;
			}
			else
			{
				result = obj;
			}
			return result;
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int? GetNotPayOrderCount(int? SalerID, int? ProductID)
		{
			SqlCommand sqlCommand = this.CommandCollection[7];
			if (SalerID.HasValue)
			{
				sqlCommand.Parameters[0].Value = SalerID.Value;
			}
			else
			{
				sqlCommand.Parameters[0].Value = System.DBNull.Value;
			}
			if (ProductID.HasValue)
			{
				sqlCommand.Parameters[1].Value = ProductID.Value;
			}
			else
			{
				sqlCommand.Parameters[1].Value = System.DBNull.Value;
			}
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			object obj;
			try
			{
				obj = sqlCommand.ExecuteScalar();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			int? result;
			if (obj == null || obj.GetType() == typeof(System.DBNull))
			{
				result = null;
			}
			else
			{
				result = new int?((int)obj);
			}
			return result;
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual object GetSuccessBusNums(int? ProductID, int? RegularBus)
		{
			SqlCommand sqlCommand = this.CommandCollection[21];
			if (ProductID.HasValue)
			{
				sqlCommand.Parameters[0].Value = ProductID.Value;
			}
			else
			{
				sqlCommand.Parameters[0].Value = System.DBNull.Value;
			}
			if (RegularBus.HasValue)
			{
				sqlCommand.Parameters[1].Value = RegularBus.Value;
			}
			else
			{
				sqlCommand.Parameters[1].Value = System.DBNull.Value;
			}
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			object obj;
			try
			{
				obj = sqlCommand.ExecuteScalar();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			object result;
			if (obj == null || obj.GetType() == typeof(System.DBNull))
			{
				result = null;
			}
			else
			{
				result = obj;
			}
			return result;
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int? GetTeamBuyLeavelByProductIDBusType(int? ProductID, int? TranTeam)
		{
			SqlCommand sqlCommand = this.CommandCollection[23];
			if (ProductID.HasValue)
			{
				sqlCommand.Parameters[0].Value = ProductID.Value;
			}
			else
			{
				sqlCommand.Parameters[0].Value = System.DBNull.Value;
			}
			if (TranTeam.HasValue)
			{
				sqlCommand.Parameters[1].Value = TranTeam.Value;
			}
			else
			{
				sqlCommand.Parameters[1].Value = System.DBNull.Value;
			}
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			object obj;
			try
			{
				obj = sqlCommand.ExecuteScalar();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			int? result;
			if (obj == null || obj.GetType() == typeof(System.DBNull))
			{
				result = null;
			}
			else
			{
				result = new int?((int)obj);
			}
			return result;
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int PR_DeleteOrder(string OrderID)
		{
			SqlCommand sqlCommand = this.CommandCollection[35];
			if (OrderID == null)
			{
				sqlCommand.Parameters[1].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[1].Value = OrderID;
			}
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int ShopAddOrderByAgent(decimal? Price_Original, System.DateTime? UpdateTime, int? Status, int? OrderFormID, int? ProductID)
		{
			SqlCommand sqlCommand = this.CommandCollection[36];
			if (Price_Original.HasValue)
			{
				sqlCommand.Parameters[1].Value = Price_Original.Value;
			}
			else
			{
				sqlCommand.Parameters[1].Value = System.DBNull.Value;
			}
			if (UpdateTime.HasValue)
			{
				sqlCommand.Parameters[2].Value = UpdateTime.Value;
			}
			else
			{
				sqlCommand.Parameters[2].Value = System.DBNull.Value;
			}
			if (Status.HasValue)
			{
				sqlCommand.Parameters[3].Value = Status.Value;
			}
			else
			{
				sqlCommand.Parameters[3].Value = System.DBNull.Value;
			}
			if (OrderFormID.HasValue)
			{
				sqlCommand.Parameters[4].Value = OrderFormID.Value;
			}
			else
			{
				sqlCommand.Parameters[4].Value = System.DBNull.Value;
			}
			if (ProductID.HasValue)
			{
				sqlCommand.Parameters[5].Value = ProductID.Value;
			}
			else
			{
				sqlCommand.Parameters[5].Value = System.DBNull.Value;
			}
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
		[DataObjectMethod(DataObjectMethodType.Update, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int UpdateAuctionOrder(int? ProductID)
		{
			SqlCommand sqlCommand = this.CommandCollection[37];
			if (ProductID.HasValue)
			{
				sqlCommand.Parameters[0].Value = ProductID.Value;
			}
			else
			{
				sqlCommand.Parameters[0].Value = System.DBNull.Value;
			}
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
		[DataObjectMethod(DataObjectMethodType.Update, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int UpdateProductSaleCount(int OrderFormID)
		{
			SqlCommand sqlCommand = this.CommandCollection[38];
			sqlCommand.Parameters[0].Value = OrderFormID;
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
		[DataObjectMethod(DataObjectMethodType.Update, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int UpdateSetTeamed(int? RegularBus, int? productid, int? TeamBuyLeavel, int? Salerid)
		{
			SqlCommand sqlCommand = this.CommandCollection[39];
			if (RegularBus.HasValue)
			{
				sqlCommand.Parameters[0].Value = RegularBus.Value;
			}
			else
			{
				sqlCommand.Parameters[0].Value = System.DBNull.Value;
			}
			if (productid.HasValue)
			{
				sqlCommand.Parameters[1].Value = productid.Value;
			}
			else
			{
				sqlCommand.Parameters[1].Value = System.DBNull.Value;
			}
			if (TeamBuyLeavel.HasValue)
			{
				sqlCommand.Parameters[2].Value = TeamBuyLeavel.Value;
			}
			else
			{
				sqlCommand.Parameters[2].Value = System.DBNull.Value;
			}
			if (Salerid.HasValue)
			{
				sqlCommand.Parameters[3].Value = Salerid.Value;
			}
			else
			{
				sqlCommand.Parameters[3].Value = System.DBNull.Value;
			}
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
		[DataObjectMethod(DataObjectMethodType.Update, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int UpdateStatusOfFirst(int? SalerID)
		{
			SqlCommand sqlCommand = this.CommandCollection[40];
			if (SalerID.HasValue)
			{
				sqlCommand.Parameters[0].Value = SalerID.Value;
			}
			else
			{
				sqlCommand.Parameters[0].Value = System.DBNull.Value;
			}
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
		[DataObjectMethod(DataObjectMethodType.Update, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int UpdateTeamBuyOrderMoneyStatus(decimal? MoneyTotal, decimal? MoneyGoods, int? Status, int? PayStatus, int? TranTeam, int? TeamBuyLeavel, System.DateTime? UpdateTime, int OrderFormID)
		{
			SqlCommand sqlCommand = this.CommandCollection[41];
			if (MoneyTotal.HasValue)
			{
				sqlCommand.Parameters[0].Value = MoneyTotal.Value;
			}
			else
			{
				sqlCommand.Parameters[0].Value = System.DBNull.Value;
			}
			if (MoneyGoods.HasValue)
			{
				sqlCommand.Parameters[1].Value = MoneyGoods.Value;
			}
			else
			{
				sqlCommand.Parameters[1].Value = System.DBNull.Value;
			}
			if (Status.HasValue)
			{
				sqlCommand.Parameters[2].Value = Status.Value;
			}
			else
			{
				sqlCommand.Parameters[2].Value = System.DBNull.Value;
			}
			if (PayStatus.HasValue)
			{
				sqlCommand.Parameters[3].Value = PayStatus.Value;
			}
			else
			{
				sqlCommand.Parameters[3].Value = System.DBNull.Value;
			}
			if (TranTeam.HasValue)
			{
				sqlCommand.Parameters[4].Value = TranTeam.Value;
			}
			else
			{
				sqlCommand.Parameters[4].Value = System.DBNull.Value;
			}
			if (TeamBuyLeavel.HasValue)
			{
				sqlCommand.Parameters[5].Value = TeamBuyLeavel.Value;
			}
			else
			{
				sqlCommand.Parameters[5].Value = System.DBNull.Value;
			}
			if (UpdateTime.HasValue)
			{
				sqlCommand.Parameters[6].Value = UpdateTime.Value;
			}
			else
			{
				sqlCommand.Parameters[6].Value = System.DBNull.Value;
			}
			sqlCommand.Parameters[7].Value = OrderFormID;
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
	}
}
